List in a query

[DanielHurtubise]

Sorry if that has been asked before (im sure it did) but i couldnt find any thread.

I have a simple query. The first field is MediaType and has 2 values (DVD or Bluray) taken from the Media Type table
Of course the query gives me a list of all the DVD and Bluray the DB has. What im trying to achieve is to run the query based on a list (DVD or Bluray).
What i was able to achieve (by using [DVD or Bluray] in the criterai) is a dialog that lets you input manually DVD or Bluray. Of course if you mispelled you get nothing.


I'd like to be able to select the possible values (DVD or bluray) from a list to avoid that and i dont care much for thedialog.

Any help is much appreciated

FYI, its a small test im doing before getting query from a Revit Database, im fairly new to Access

[pbaldy]

The only way to get a list is to use a form. You'd have the user choose from a combo box, and the query criteria would be:

Forms!FormName.ComboName

[DanielHurtubise]

Thanks a lot for the info, and it's good enough for me
Here's where i got so far.


The form still returns only 1 value (of course there's multiple). How do i "link the ComboBoc value to the Query?

Thanks a million for your time and help.

[pbaldy]

I'm assuming you want to choose at the top and have the values appear below? You'd base the form on your query, and requery the form in the after update event of the combo.

[DanielHurtubise]

That's EXACTLY what im after