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.
|
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. |