continuous form add record

C

Cynthia

I cannot get my form to allow the user to add q new record.
This is a continuous form.
I have set the allow additions to yes, but still not able to add a
record?
if I set Data Entry to yes I get now records.
What setting am I missing
 
D

Dirk Goldgar

Cynthia said:
I cannot get my form to allow the user to add q new record.
This is a continuous form.
I have set the allow additions to yes, but still not able to add a
record?
if I set Data Entry to yes I get now records.
What setting am I missing
Click to expand...

Probably the query on which the form is based is not updatable. Most
simple queries involving one or two tables are updatable, but more
complex queries may not be. See the help topic, "When can I update data
from a query?"
 
C

Cynthia

Dirk,
Thank you for your time on this. I found my problem. I had to add the field
that autonumbers to be able to update the form.
 
D

Dirk Goldgar

Cynthia said:
I am pulling the data straight from the table with no filters.
Click to expand...

Hmm. Is your database open in read-only mode? If you open the table
directly as a datasheet, can you edit it? Is this a local table in your
..mdb file, or is it a linked table? Is user-level security in effect,
such that you might not have permission to update this table?
 
Top