Form is blank

[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

 

[t t via AccessMonster.com]

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.

 

[Steve Schapel]

Dou,

The first thing I would check is the Allow Additions property of the
form. It should be set to Yes.

 

[Dou]

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

 

[Steve Schapel]

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

 

[Dou]

Yes, Thank you very much.

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