Link to home
Start Free TrialLog in
Avatar of Davisro
DavisroFlag for United States of America

asked on

Access Unbound Combo Box Not Working in accde

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

Avatar of Kelvin Sparks
Kelvin Sparks
Flag of New Zealand image

What version of Access are you running?
Avatar of Davisro

ASKER

Part of MS Office Professional Plus 2010
v14.0.7166.500 32 bit
ASKER CERTIFIED SOLUTION
Avatar of Kelvin Sparks
Kelvin Sparks
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Davisro

ASKER

ok thanks