Blank form when file empty

  • Thread starter Thread starter pvp
  • Start date Start date
P

pvp

I have a form based on a database file. If, by deleting
records in that file from the form, I get to the point
when the file is empty, my form goes blank - no fields,
buttons, ...

Is there any way I can avoid this when the file empties
and just have the form but with no field contents
insteadd of no form?

Thanks.
 
That happens if there are no records to show, AND no new records can be
added.

You can prevent it by ensuring your form has an updatable recordset, and not
setting AllowEdits to No. If necessary, you can prevent new records from
being added by cancelling the Form_BeforeInsert event.
 
Many thanks, Allen. And your website looks very useful -
I have bookmarked it.

Btw, can you help me with my other post, about Screen
Resolution switching? Not that I'm pushing my luck or
anything...

peter
 
Back
Top