Blank Form - Empty Query

I have a form that coming up blank when the query that drives the form is
empty. Is there anyway to get around this. One problem is that there are
other controls on the form the operator needs to follow.
If all else fails - if there was an event "on No data" like in a report
where I could redirect the operator down another path?
--
Thanks for any assistance

NNlogistics,
There may be more elegant solutions but... this should work.
Assuming you're clicking a button to open the form, you could always interrogate the
query with a DCount before the form opens.
0 records... then open the form normally.
= 0 records... then post msg to user "No Data", and exit sub without opening the form.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"NNlogistics" wrote in message
...
I have a form that coming up blank when the query that drives the form is
empty. Is there anyway to get around this. One problem is that there are
other controls on the form the operator needs to follow.
If all else fails - if there was an event "on No data" like in a report
where I could redirect the operator down another path?
--
Thanks for any assistance

See:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html
for the cause and workarounds.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"NNlogistics" wrote in message
...
I have a form that coming up blank when the query that drives the form is
empty. Is there anyway to get around this. One problem is that there are
other controls on the form the operator needs to follow.
If all else fails - if there was an event "on No data" like in a report
where I could redirect the operator down another path?
--
Thanks for any assistance

--
Thanks for any assistance


"Allen Browne" wrote:

See:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html
for the cause and workarounds.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"NNlogistics" wrote in message
...
I have a form that coming up blank when the query that drives the form is
empty. Is there anyway to get around this. One problem is that there are
other controls on the form the operator needs to follow.
If all else fails - if there was an event "on No data" like in a report
where I could redirect the operator down another path?
--
Thanks for any assistance

Thanks all

I used
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox (" There are no outstanding 'Manufacturer Returns' RETURN TO
SHIP/RECEIVE Menu")

End If
Thanks again - Have a happy holiday