Software

Ask something
Discussion Locked

Access question prompt

0 helpful
3 replies

by dakota99

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is it possible to get a query criteria box to link with a table to create a combo box type selection box. I know that it is possible to get a prompt in a query by enclosing your question inside [ ]. Is it possible when the query is run, to have the criteria prompt be a combo box that is linked to another table?

3 replies

by ptaylor

Check out this site.

http://support.microsoft.com/support/kb/articles/Q208/5/29.asp?PR=ACC

The criteria being queried is based off of a created form. When you open the form, a popup box appears allowing the user to filter the entries needed for a report. The filtering can consist of numerous choices as long as they are part of the original table or query. If you find this will give you a solution, you will need to combine the tables needed for your search in a query, then create the form off the query to give adequate links.

I hope this will help you in your solution. Good luck.

This discussion is closed to new replies.