Displaying a Message Box

[egstatus]

Hi all,
I have created a form that is using a querry to seach for an employee number.
I want to be able to display a message box that says that the "employee number was not found" if the employee number entered is not in the database.

Where/how do I put the code to display the message box?

Thanks

Ed

 

[LaurieHamlin]

If I'm understanding you correctly and you're using a recordset, try this.
If recordset.recordcount = 0 Then
MsgBox("employee number was not found")
End If

 

[egstatus]

Thanks for the reply.

The form record souce is a querry. [Is that what you mean by a recordset?]

In which event to I put the code. Form Load?


Thanks

Ed

 

[ssatech]

And is this form based on a Parameter query?If so, put on the On Open event of your form.

Or do you have a field in the form and a command button that runs this query

 

[Pampers]

You can set it at the same event when the query executes

If me.recordsource.recordcount = 0
Msgbox "No records were found"
End if

Pampers
Just let it go...

 

[egstatus]

Thanks all for the help.

Ed