Data Entry in Form

Hello,
I have created a data entry form, but cannot enter data into it. The fields
are frozen. Under the Data Tab for form properties;
Data Entry is marked Yes
Allow Additions is marked Yes
Allow Deletions is marked Yes
Allow Edits is marked Yes

What am I missing. Is there some other data or event that needs to be
enabled? Using Access 2007. Thank you for any assitance.

Make sure each data entry control has properties enabled=true and locked=no.
How are you opening the form?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Novice2000" wrote:

Hello,
I have created a data entry form, but cannot enter data into it. The fields
are frozen. Under the Data Tab for form properties;
Data Entry is marked Yes
Allow Additions is marked Yes
Allow Deletions is marked Yes
Allow Edits is marked Yes

What am I missing. Is there some other data or event that needs to be
enabled? Using Access 2007. Thank you for any assitance.

Novice2000 wrote:
Hello,
I have created a data entry form, but cannot enter data into it. The fields
are frozen. Under the Data Tab for form properties;
Data Entry is marked Yes
Allow Additions is marked Yes
Allow Deletions is marked Yes
Allow Edits is marked Yes

What am I missing. Is there some other data or event that needs to be
enabled? Using Access 2007. Thank you for any assitance.

Make a backup of your database first.

Then look at the "Record Source" of the form (use the Properties window
and select Form in the drop-down at the top). The Record Source could
be a single table, or a query based on one or more table. Open the
table or run the query as appropriate. Try adding a record. If you
can't, then solve that problem first. If you can, then we need to look
at the form. Incidentally, the "Data Entry" property on a form tells
Access to open the form ready to input a new record, rather than
displaying the first record.

If you're new to this, then try creating a basic test table, and put a
record or two in it. Create a simple query based on that table. Then
use the Form Wizard to create a form based on the query. See if you can
update that - most likely you can. Might give you a useful frame of
reference.

HTH

Phil, London

At this point it is brand new and I am opening it by clicking it no
switchboard. All of the fields are enabled=yes and locked=no except for one
field that I do not want others to be able to change. Still not allowing data
entry.

"Dorian" wrote:

Make sure each data entry control has properties enabled=true and locked=no.
How are you opening the form?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Novice2000" wrote:

Hello,
I have created a data entry form, but cannot enter data into it. The fields
are frozen. Under the Data Tab for form properties;
Data Entry is marked Yes
Allow Additions is marked Yes
Allow Deletions is marked Yes
Allow Edits is marked Yes

What am I missing. Is there some other data or event that needs to be
enabled? Using Access 2007. Thank you for any assitance.

If, as it sounds, your form is based on a query, made up of multiple tables,
and you cannot add or edit records when opening the query directly, goto

http://allenbrowne.com/ser-61.html

and read Allen Browne's explanation and suggestions for correcting the
problem.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200909/1

Thank you both. The problem turned out to be two items. I had two tables
joined to the main table with an Automatic ID Key when I should have made the
key part of the customer number which is key in the main table. The other
item was that in the Property Sheet Data tab I had Data Entry marked no.

"Philip Herlihy" wrote:

Novice2000 wrote:
Hello,
I have created a data entry form, but cannot enter data into it. The fields
are frozen. Under the Data Tab for form properties;
Data Entry is marked Yes
Allow Additions is marked Yes
Allow Deletions is marked Yes
Allow Edits is marked Yes

What am I missing. Is there some other data or event that needs to be
enabled? Using Access 2007. Thank you for any assitance.

Make a backup of your database first.

Then look at the "Record Source" of the form (use the Properties window
and select Form in the drop-down at the top). The Record Source could
be a single table, or a query based on one or more table. Open the
table or run the query as appropriate. Try adding a record. If you
can't, then solve that problem first. If you can, then we need to look
at the form. Incidentally, the "Data Entry" property on a form tells
Access to open the form ready to input a new record, rather than
displaying the first record.

If you're new to this, then try creating a basic test table, and put a
record or two in it. Create a simple query based on that table. Then
use the Form Wizard to create a form based on the query. See if you can
update that - most likely you can. Might give you a useful frame of
reference.

HTH

Phil, London