DB Adding a new record when form is based on a query

[Desert Bear]

I have a form based on a query as the data comes from 3 diferent tables
I can edit information in the fields, but when I click on "Add New Record
I can't enter any data in the fields
What do I need to fix
The query recordset type is "Dynaset"

 

[Jonathan Parminter]

-----Original Message-----
I have a form based on a query as the data comes from 3 diferent tables.
I can edit information in the fields, but when I click on "Add New Record"
I can't enter any data in the fields.
What do I need to fix?
The query recordset type is "Dynaset"
.

Hi Desert Bear,
can be several things that you need to check.

As a guess you might like to check that the joins are all
type 1.

Then check that you have not inadvertantly included a
primary key field in the grid when you should use the
matching foreign key.

If the above still does not resolve the problem you might
like to remove one table at a time and test whether the
removed table freedup new record entry. This may help to
spot the possible cause.

Luck
Jonathan

 

[Desert Bear]

Thanks--I'll work on it.

 

[Dirk Goldgar]

I have a form based on a query as the data comes from 3 diferent
tables. I can edit information in the fields, but when I click on
"Add New Record" I can't enter any data in the fields.
What do I need to fix?
The query recordset type is "Dynaset"

Adding to Jonathan Parminter's response, see the help topic "When can I
update data from a query?"