By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

Find record using Combo box

P: n/a
May any one can teach me the easy way to create a combo box in a form
to find record.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Rog
The easy way is to let the wizard do it for you. Select the "find a
record on my form based on the value I selected" option.

If you want to do it yourself, you need to enter code in the
afterupdate event of your combo. Example:

Me.RecordsetClone.FindFirst "[EmployeeName] = " & Chr$(34) &
Me!cboNames & Chr$(34)
Me.Bookmark = Me.RecordsetClone.Bookmark
Me!cboNames = ""
Leave out the Chr$(34)s if it's a numerical value.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.