message box

[mhtmarsha]

I would like a message box to pop-up on the form load event that would aske the user for a last name then search the last name field for that name. I am using an application that allows the user to choose a form and then lookup a person by last name but they can not edit or change anything in the form. I thought maybe a message box that would ask for the last name but I don't know the code it would need in order to search just the start of the last name field. Does anyone have any ideas.

 

[Jack Cowley]

You will need to create a form that pops up with an unbound field and a command button as a Message box will not do what you want.

Have the command button set to open the form you want and be sure that form is based on a query.

In the query in the LastName column and in the Criteria field put code like this:

Like [Forms]![YourPopupFormName]![UnboundFieldNameOnTheForm] & "*"

Now when the user types in jo in your popup form and clicks the command button the form will show Johns, Johnson, Jones, etc.

Hurray for Paducah!

 

[mhtmarsha]

THANKS I'll try it and let you know. Once again thanks for your help.

 

[jimbrooking]

Would an InputBox work to acquire the search name?