Solved

Access Unbound Combo Box Not Working in accde

Posted on 2016-09-26
4
67 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

739 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