Message box linked to query and form 1

[hwmueller]

Hi

I am having problems getting a query that is called up by a form to work the way I want! What I want is that when selected in the switchboard, a question pops up which says "Enter Staff Members Name". If this corresponds with an actual name, then a form opens with the details corresponding to that name. If no such name exists, a second pop up should appear which says "No such name, please try again". Is this possible??

Thanks

Hans

 

[Psychpt]

what you would need to do is create a recordset first and test if the recordcount = 0
if you need more assistance e-mail me
i have several samples.
psychpt@aol.com