Full Version: Combo Box code not working
UtterAccess Forums > Microsoft® Access > Access Forms
Newbie_Beth
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?
Thanks!
theDBguy
Hi,
Welcome to Utter Access!
Try creating a new combobox using the Wizard and select the third option: "Find records.."
Hope that helps...
Newbie_Beth
Thanks!
pparently I like to try to make things hard and didn't even think about using the wizard.
Works perfectly now!
-Beth
theDBguy
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.