Query off of a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make a query in access based on the value in a drop down menu of a
form?? I have a form where I want to have the user click a button to bring up
a query of another table based on what is selected in a drop down menu on the
form.
Any info may help! Thanks.
-Andrew
 
roadsign71 said:
How do I make a query in access based on the value in a drop down
menu of a form?? I have a form where I want to have the user click a
button to bring up a query of another table based on what is selected
in a drop down menu on the form.
Any info may help! Thanks.
-Andrew
Click to expand...

SELECT *
FROM TableName
WHERE FieldName = Forms!NameOfForm!NameOfComboBox
 
roadsign71 said:
where do you put that code at??
Click to expand...

It's not code. It's the SQL of a query (we can't post a picture of the query
designer in these groups.)

Substitute the names of your Table, Fields, Form, and ComboBox, paste it
into the SQL view of a new query and then switch to design view.

 
Back
Top