Add new record in Form

H

Hafeez

I have a form based on a Dynaset query. The query is
based on two tables linked one-to-many in the relationship
window and linked via a left join from the many-to-one in
the query desing window.
While in query mode, I am able to make changes to the
records as well as add new records. But when I use my
form, I can only modify data, I can't add records.

Please help
TIA
Hafeez
 
D

Dirk Goldgar

Hafeez said:
I have a form based on a Dynaset query. The query is
based on two tables linked one-to-many in the relationship
window and linked via a left join from the many-to-one in
the query desing window.
While in query mode, I am able to make changes to the
records as well as add new records. But when I use my
form, I can only modify data, I can't add records.

Please help
TIA
Hafeez
Click to expand...

Check the form's AllowAdditions property. Is it set to No? Should be
Yes.
 
Top