Search for a record

[djepson]

I have created a simple form that points to a table in access. It updates and pages through the records fine.

However, I want to the ability to search for a record based upon the sku field. Once the match is found, it needs to display the values for that record in the form.

Is there an easy way to do this?

Any help is greatly appreciated.

 

[pdx_man]

Oh yeah, way easy and COOL!

(In design view of your form)
First, make sure the Control Wizards button is selected on your toolbox toolbar. (If any of these terms aren't familiar, check them out under Help) Then select the combo box control and click on your form. Follow the instructions. Be sure to read each wizard box thoroughly)

 

[ywcai]

I have created the combo box on the form which have a list of all the records. But when I click one of the record, I got the message says: Control can't be edited. It bound to autonumber field...
What the problem here? Help!
Thank you in advance.