Parameter Prompt

  • Thread starter Thread starter DSmith
  • Start date Start date
D

DSmith

How do I make a prompt to ask for two or more items in a query for a report
or form?

Such as first name and last name.

Thanks
 
I would try to either use a parameter query or use a form with combo boxes to
ask for first and last name.
 
How do I make a prompt to ask for two or more items in a query for a report
or form?

Such as first name and last name.

Thanks
Click to expand...

Not knowing your level, I'll make it simple as possible. In the query
in design mode, go to field for First Name, in the criteria line,
enter the prompt in [square brackets]. You can do this with multiple
fields in the same query, the boxes will pop up one after the other.
 
Ok, what if I have 3 criteria for the same field, how would I design a
prompt for that?
 
Ok, what if I have 3 criteria for the same field, how would I design a
prompt for that?
Click to expand...

[Enter a search term:] OR [Enter an alternative search term:] OR [Enter a
third search term:]
 
Back
Top