Add new record in Form

[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

 

[Dirk Goldgar]

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

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