Display Error Message

  • Thread starter Terry DeJournett
  • Start date
T

Terry DeJournett

Can I get an error message to display if a select query does not find any
records? And can it be customized?

Thanks in advance.
 
F

fredg

Can I get an error message to display if a select query does not find any
records? And can it be customized?

Thanks in advance.
Click to expand...

Not using a query, but if you create a form using the query as it's
record source to display the query results you can.

Set the Form's Default View property to Datasheet and it will look
just like a query.

You can code the form's OPEN event to not open the form if there are
no records:

If Me.RecordsetClone.RecordCount = 0 then
MsgBox "There are no records to display."
Cancel = True
End If
 
Top