View Full Version : opening a form with user input OnOpen


yeatmanj
10-11-2000, 11:54 AM
I have a button set up to open a form. When the button is clicked i want it to ask for a # and open the related record when the # is entered.

chrismcbride
10-11-2000, 04:19 PM
The easiest way to do this is to base the destination form on a Query. In the Criteria line of the field you would like to search in, add a user prompt [ENTER #] and include the brackets. When the source form executes the OpenForm method, the query will be called and it will ask for the number.
If you don't want to change the destination form's source then you will have to use the InputBox function. Lots in the help files regarding the use of Input boxes...
Good Luck
Chris

yeatmanj
10-20-2000, 09:55 AM
The input box was the way to go. Thank you for your help.