Beginner Form help

[Lucien]

I am trying to create a form view from a table that I have. What I want to
do is have one field on the form available for input which will display the
form fields related to the input field. For example: In my "Purchasing
Group" field - you can enter 86P and the rest of the fields will display
records relating to 86p. How do I do this? I currently have the basic form
where you have to navigate through each record.

 

[Ed Robichaud]

Create an unbound combobox to serve as a filter for your form. Use the
wizard and follow the prompts for "Find a record based on......."

Look at Northwinds or any of the template-based mdb's that ship with Access
for working examples.
-Ed

 

[Lucien]

That did it. Thanks for the help!

Create an unbound combobox to serve as a filter for your form. Use the
wizard and follow the prompts for "Find a record based on......."

Look at Northwinds or any of the template-based mdb's that ship with Access
for working examples.
-Ed