forms don't have a "nodata" event, do they? I just looked....I don't think they do. Basically, you need to check the recordcount of the form's dataset and issue .visible properties to the controls of choice based on the result of 0 or >0.
what comes to mind to check this on the "open" event is:
Code:
on error resume next
dim rs as dao.recordset
set rs = me.recordsetclone
rs.movelast
rs.movefirst
if rs.recordcount = 0 then
'do something
else
'oops! records exist. keep it the way it is!
end if
rs.close
set rs = nothing