Solved

Access Unbound Combo Box Not Working in accde

Posted on 2016-09-26
4
71 Views
Last Modified: 2016-09-26
I have an unbound record-search combo-box on a form that after awhile stops working when I publish the database as an accde but I dont know why. Each time it happens, replace the database with a new accde version, but it keeps happening. Is it the VBA code or something else? The code behind it is below:

Form Object:
Private Sub cboSearchName_AfterUpdate()
    Me.chkSupportTerms = False
    Me.chkNonSupportTerms = False
    If Me.cboHRPartner <> "" Then Me.cboHRPartner = ""
    mForms.cboSearchName Me
End Sub

Open in new window


Module
Sub cboSearchName(frmMe As Form)
    Application.Echo False
    DoCmd.ShowAllRecords
    frmMe.SupportEmployee.SetFocus
    DoCmd.FindRecord frmMe.cboSearchName, acAnywhere, False, acSearchAll, True
    Application.Echo True
End Sub

Open in new window

0
Comment
Question by:Ron
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 41816744
What version of Access are you running?
0
 

Author Comment

by:Ron
ID: 41816749
Part of MS Office Professional Plus 2010
v14.0.7166.500 32 bit
0
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 41816757
0
 

Author Closing Comment

by:Ron
ID: 41816767
ok thanks
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question