Data Entry "Property" Not working

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

Guest

I created a form joining two tables via the form wizard function. This type
of form allows fields from one table to automatically populate fields from
the other table within the form (easier than using code). The autopouplate
functions works charmingly, but I do have one problem:

I can't seem to add new records.

In the form properties window under the data tab, "data entry" is set to no.
Additions, deletions, edits are set to yes. Recordset = dynaset. Record
lock = no locks. Fetch defaults = yes.

What property should I adjust/make so that I can use this form to add new
records to this form?

Thank you.
 
jcinn(cylvia) said:
I created a form joining two tables via the form wizard function.
This type of form allows fields from one table to automatically
populate fields from the other table within the form (easier than
using code). The autopouplate functions works charmingly, but I do
have one problem:

I can't seem to add new records.

In the form properties window under the data tab, "data entry" is set
to no. Additions, deletions, edits are set to yes. Recordset =
dynaset. Record lock = no locks. Fetch defaults = yes.

What property should I adjust/make so that I can use this form to add
new records to this form?

Thank you.
Click to expand...

Make sure your query includes the primary key field of the table you
want to add records to.
 
Back
Top