Find

CodeCracker0291

Registered User.
Local time
Today, 15:44
Joined
Jan 19, 2002
Messages
33
Yes, I want to make a macro for that will allow the user to input a persons last name and then the macro searches the form to find that persons record. I'm making it for a switchboard but I want it as a macro and then the switchboard will run the macro. Thank You.
 
I am a little confused by your question but will make this suggestion. Create a Combo box on your 'switchboard' that has the RecordID and the Last name. Create a Command button using the Wizard. When asked by the Wizard if you want to open the form to a specific records select that option. Select the appropriate fields in the list boxes and finish the Wizard. Now when you select a last name from the Combo box and click your Command button the form will be opened to the selected record.
 

Users who are viewing this thread

Back
Top Bottom