Data entry via a form

  • Thread starter Thread starter ANN
  • Start date Start date
A

ANN

I'm working on a database, and two of three forms are
allowing me to input additional information- which is what
I want. One won't. I have done the stare & compare w/
the other forms in the same database, the other tables
linked to those forms, etc., and can't find a difference.
Nothing is locked, as far as I can tell. Help!

TIA
 
One more thing:

When in 'form view', the arrow on the left side of the
form stays an arrow when I attempt to add information- it
does not go to a 'pencil' for new row addition- and in the
#/record area (record: X of Y) it does not allow to click
to a new record, it only allows up to the last entry in
the table.

The table itself allows new entries.

It is as if the form is write-protected but I can't find
where to turn it off.

Thanks again.
 
One more thing:

When in 'form view', the arrow on the left side of the
form stays an arrow when I attempt to add information- it
does not go to a 'pencil' for new row addition- and in the
#/record area (record: X of Y) it does not allow to click
to a new record, it only allows up to the last entry in
the table.

The table itself allows new entries.

It is as if the form is write-protected but I can't find
where to turn it off.
Click to expand...

Some places to check:

Open the Form in design view and view its Properties. Is the "Allow
Updates" property True?

Check its Recordsource property; click the ... icon by it. If your
form is based on a Query, is that query updateable? (If it's based
directly on a Table you'll be asked if you want to convert it to a
query - don't bother).
 
Back
Top