Can not enter data in form view

[Guest]

I created a form based on two tables. I am unable to enter any data in the
form fields. I checked the field properties and the locked is set to "No".

Can someone suggest how to correct this problem?

Thank you

 

[John Vinson]

I created a form based on two tables. I am unable to enter any data in the
form fields. I checked the field properties and the locked is set to "No".

Can someone suggest how to correct this problem?

Thank you

Make the Query upon which the form is based updateable. See
"Updateable" in the online help for some reasons why a query might not
be updateable; common reasons are the lack of a Primary Key or a
defined relationship between the tables, the use of any Totals
operation, or other possibilities.

Any reason not to do the usual thing and use a Form of the "one" side
table and a Subform for the "many"?

John W. Vinson[MVP]

 

[John Vinson]

Thank you. I am working with a database that was created with a one-to-one
relationship with all the tables and has the property of the linked filed as
set to "Indexed - Duplicates Yes"
It is making it very difficult to work with the program

If you were given an automobile with a broken transmission and a
leaking coolant system, you'ld get it fixed... right?

You're working with an incorrectly structured database. Rather than
trying to fix it with duct tape and glue, *fix the design*.

If it truly is a one to one relationship then the index should be
Indexed... Duplicates No. But a database with one to one relationships
between all the tables simply makes NO SENSE AT ALL, and must be
redesigned before you'll be able to get *any* productive work done.

John W. Vinson[MVP]