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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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