Change controls on an empty form

[Dom]

I have a split form with various options on it. I want those options to change if the form has no records to display. So, if there are records, there will be one set of options, and if there are no records, there will be another set. Any advice greatly appreciated! Thanks.

[ajetrumpet]

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:

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

[Dom]

Thanks! I tried something similar but it didn't work, so I'll try yours!