Form Open Run-Time Error 2427 1

[sebell]

I have a form reading from a query. If there is no data in the query I get a run-time error 2427 - 'You entered an expression that has no value.'
Is there any way to check for data before opening up the form and if there is none bring up a msgbox?

Thank you in advance for your help,
Sherry

 

[glalsop]

Try something like this in the form's OnOpen event:

if me.recordset.recordcount = 0 then
msgbox "No records, cancelling",vbokonly
cancel = true
end if

-Gary

 

[sebell]

Gary,
That worked great!!
Thank you,
Sherry