Parameter Prompt

[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

 

[Golfinray]

I would try to either use a parameter query or use a form with combo boxes to
ask for first and last name.

 

[Lotto]

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

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.

 

[DSmith]

Ok, what if I have 3 criteria for the same field, how would I design a
prompt for that?

 

[John W. Vinson]

Ok, what if I have 3 criteria for the same field, how would I design a
prompt for that?

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

 

[DSmith]

Thanks