Parameter Form, Query and display form - checking for null value??

[coder30]

I have a parameter form that feeds the memberID to a query, the query result is displayed in another form. If the memberID is not found in the query the resulting form is blank. I would like to display a label (or message box) that says "Member Not Found" instead of just a blank form result. I've tried to check if MemID object is null upon opening the resulting form, but that didn't work. I'm sure I have to check for null on the query, but code the event on the form. Does anyone know how I should code this event?

 

[jebry]

Hi!

You can open a recordset using the query and check if there are any records that way.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[coder30]

Can you give me an idea of how this is done in VBA? I'm pretty new to coding outside of the typical event procedures.

 

[sozzer]

Private Sub Form_Open(Cancel As Integer)
If Me.Recordset.EOF = True Then
DoCmd.Close
MsgBox "No data"
Else
End If
End Sub

 

[coder30]

Thanks!
Works like a charm