Putting Information from a query into a form

  • Thread starter Thread starter Amanda.Perez.09
  • Start date Start date
A

Amanda.Perez.09

Hi,

I'm not sure if it is possible to do what I want to do, but I have a
combo box that I have given a DISTINCT stantement so that it only
lists part numbers once, even though in the source table it could be
listed multiple times.
Once someone selects the part number, I want a form to come up that
lists everything related to the selection made in the combo box.

I feel like I've tried everything. I am not too familiar with Access
and I'm barely familiar with macros, meaning I know nothing about SQL
or VB or anything of that nature. If someone could help me I would
greatly appreciate it.

Thank you!

Amanda
 
Amanda,
there are examples of how to do this in the northwind sample database.
On the access menu go to Help | Sample databases | Northwind.

I assume you have built a form that shows all the info you want to show
about the part number.
To open this form from your combo, create a macro using the open form
action.
Use the form combo in the lower pane of the macro to tell access which form
to open.
Use the where condition in the macro - lower pane- to tell access which
record to show.
Press F1 for help on writing the where condition.

Jeanette Cunningham -- Melbourne Victoria Australia
 
Back
Top