Empty Table won't accept records

[Russ]

Whether through form or vba, table will not accept new
records. If I manually open the table and create
a "dummy" record, any method of adding a record will work
fine. Is there a way to omit a dummy record and still
update the table? The dummy record causes other problems.

 

[Duane Hookom]

Tables almost always accept new records. How are you using code or a form
that you can't add? Are you getting an error message? "Update" is generally
used to update an existing record while "append" is used to specify adding a
record.

 

[Russ]

the form can be bound to the table by setting the data
source property to the table, or without such a direct
link, a recordset could be set to the table and an update
used.
After adding a dummy record anything works. The problem
is that the dummy record causes other problems. The fact
that the problem only occurs when the table is empty
validates the entry methods used in my mind. I just can't
get the same methods to work when the table is new. Can
you tell me of anything that would cause this problem?

 

[Duane Hookom]

Are you getting any error messages?
Did you set the form's Record Source property to a table or an updateable
query?
Are these native Access tables?
Have you placed bound text boxes on your form?
Are your form properties set to allow additions?
Are there any relationships between your form's record source and other
tables?