Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 82
  • Last Modified:

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

0
Ron
Asked:
Ron
  • 2
  • 2
1 Solution
 
Kelvin SparksCommented:
What version of Access are you running?
0
 
RonAuthor Commented:
Part of MS Office Professional Plus 2010
v14.0.7166.500 32 bit
0
 
RonAuthor Commented:
ok thanks
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now