Access 2007: Simple Combo Box to search records in a table

Working with Microsoft Access 2007:

I am having a hard time setting up a simple combo box that searches/filters records in my form. I want to search for a piece of hardware based on an Asset_number (field) in my table.

Access 2010 seems to provide a simple approach of walking you through a wizard, according to youtube videos. That is, select the first screen on the wizard: "Find a record on my form based on the value I selected in my combo box".

However I am using Access 2007 and I am not sure how to go about this....

Please help!
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

The same functionality is available in A2007 and even earlier versions of Access.  Are you not getting the three options when you add the combo to the form?Combo Box Wizard
If you are only getting the first two options, it is because the form is not bound.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jabal_AwliyaAuthor Commented:
Hi there ....

I am getting only the first two options, unfortunately. I would love to see the third option.

How do I make the form bound?
Jabal_AwliyaAuthor Commented:
To be clear I am actually using  a tab control
Jabal_AwliyaAuthor Commented:
I got it....I made the form data bound....thx
In a tabbed form, typically, each tab contains a separate subform.  It is really unusual for all the tabs to be pulling columns from the same record.  If that is your situation, you might want to look at your design.

Notice that the third option says - find a record on my FORM.  

To bind a form to a table or query, you would enter the name of the table or query in the Form's RecordSource property.  That is the recordset that would be searched.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.