Form to enter new records only

[randolphoralph]

I am trying to figure out how to have a form enter new records only. Currently, my form opens and pulls all the records from the table. I was wondering if it is possible to have the form open with blank fields and enter new records to the table and not display all the records from the table.

 

[pbaldy]

Set the form's Data Entry property to Yes.

 

[randolphoralph]

I have done that and the form opens blank with no fields.

 

[pbaldy]

That would imply that either it has no record source, or the record source is a read-only query. Is either the case? Can you add records with that property set to No?

 

[randolphoralph]

Yes I am able to add records with the Data Entry property set to No

 

[randolphoralph]

The record source is set to the table name.

 

[randolphoralph]

I do have one of the field's control source set to perform a DCount on the table...I am not sure if that would effect it.

 

[pbaldy]

I wouldn't think the DCount would affect it, but I'm not sure. Can you post the db?