User input criteria

[PsyberFox]

Hi,

So I've got a form based on a query with user input criteria - no problem.
However, on asking the user for input, is there a way to restrict his/her
input by certain lookup criteria, i.e. to only look up the value necessary
for an input field from a certain table. A drop-down box would be even more
blud-e marvelous!

Thank you!

 

[Allen Browne]

Access cannot give you a combo for the parametrer in a query.

However, if you create a form with a combo, you can refer to it in the
query, e.g.:
[Forms].[Form1].[Combo22]

 

[PsyberFox]

Thank you... I also found this link to show a blud-e wonderful tutorial for
things like this:

http://www.fontstuff.com/access/acctut08.htm#dialog

Thank you again!

Access cannot give you a combo for the parametrer in a query.

However, if you create a form with a combo, you can refer to it in the
query, e.g.:
[Forms].[Form1].[Combo22]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

So I've got a form based on a query with user input criteria - no problem.
However, on asking the user for input, is there a way to restrict his/her
input by certain lookup criteria, i.e. to only look up the value necessary
for an input field from a certain table. A drop-down box would be even
more blud-e marvelous!