In the database I am desiging I have created a querie that will prompt for user input, in this case it will prompt for a name and date and then return a certain list. My concern is that this list might not be accurate when an invalid date and/or name is entered. Is there any way (like one would find in a form field) to restrict the user input with an input mask in this dialog box and/or make a selection from a restricted list?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Input mask for user input into querie possible? 1
- Thread starter ddelport
- Start date
-
1
- #2
Hi!
As far as I know, that's not possible within queries. Best alternative is to put textboxes or comboboxes on the form where you call the query (report), and then use reference to these in the queries in stead of parameters.
So in stead of [Enter Date here:]
Refer to the control holding the date on the form:
[tt]Forms!YourForm!YourDate[/tt]
This will allow the usual means of validating info prior to running the query.
Roy-Vidar
As far as I know, that's not possible within queries. Best alternative is to put textboxes or comboboxes on the form where you call the query (report), and then use reference to these in the queries in stead of parameters.
So in stead of [Enter Date here:]
Refer to the control holding the date on the form:
[tt]Forms!YourForm!YourDate[/tt]
This will allow the usual means of validating info prior to running the query.
Roy-Vidar
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
