Form is blank

  • Thread starter Thread starter Dou
  • Start date Start date
D

Dou

I have a form, the record source is a linked table. if the table has
records, the form can display records, if the table is empty, then the form
is blank when open this form. I want the form still display all text box
when the table is empty. how to solve this problrm?

Thanks
 
in design view at the top left side of form click properties.
click data tab and select add record as yes , save the form
if your opening form read only then change as edit.
after opening the form you can go to new record using macro or basic code.
 
Dou,

The first thing I would check is the Allow Additions property of the
form. It should be set to Yes.
 
This form just display data, don't add data. Do you have any way to display
this form, but stiill set Additions property to No. thanks
 
Dou,

What you want is to only show the existing records if there is data, but
show a blank record if there is no existing data. Is this right? Well,
you could use a VBA procedure on the Open event of the form to control
this. Something like this...
Me.AllowAdditions = DCount("*","YourTable") = 0
 
Yes, Thank you very much.

Steve Schapel said:
Dou,

What you want is to only show the existing records if there is data, but
show a blank record if there is no existing data. Is this right? Well,
you could use a VBA procedure on the Open event of the form to control
this. Something like this...
Me.AllowAdditions = DCount("*","YourTable") = 0
Click to expand...
 
Back
Top