Data Entry in Form

  • Thread starter Thread starter Novice2000
  • Start date Start date
N

Novice2000

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 said:
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.
Click to expand...

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.
 
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.
 
Back
Top