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

On Tue, 19 Dec 2006 19:51:00 -0800, hkhella
<(E-Mail Removed)> wrote:

>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]

On Wed, 20 Dec 2006 04:46:01 -0800, hkhella
<(E-Mail Removed)> wrote:

>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]