I searched previous threads but cant make too much sense of this.
I know this is easy I have done it before but I am VERY rusty right now....
I have a table field that is a look up field in the table or form. When that feild is used in a Query it is grabbing all records.
How do I get the criteria in the Query to prompt the user to pick one of the list from the lookup list in the table?
not [Please type in criteria] but rather select one from this list
Did that make sense?
TIA
I know this is easy I have done it before but I am VERY rusty right now....
I have a table field that is a look up field in the table or form. When that feild is used in a Query it is grabbing all records.
How do I get the criteria in the Query to prompt the user to pick one of the list from the lookup list in the table?
not [Please type in criteria] but rather select one from this list
Did that make sense?
TIA