Full Version: Combo Box code not working
UtterAccess Forums > Microsoft® Access > Access Forms
Help please! I am a newbie and this is my first attempt at code.
I have a combo box on a single form intended to retrieve records by the field ID.
The code is working incorrectly and instead of jumping to the intended record, it is advancing to the next record in sequence.
The combo box is in the form details.
Private Sub POLookup_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[PO] = ' & Me![POLookUp] & " '"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
Can anyone help me figure out what I have wrong?
Welcome to Utter Access!
Try creating a new combobox using the Wizard and select the third option: "Find records.."
Hope that helps...
pparently I like to try to make things hard and didn't even think about using the wizard.
Works perfectly now!
You're welcome, Beth. Glad to hear you got it working now. Good luck with your project.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.