Form linked to table help

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I have a subform that picks up two dates (two separate fields from a table).
This then allows the user to amend the dates from the subform which are then
referenced in some queries. However, looking at the core table there are now
3 records in there instead of one, probably due to a user tabbing within the
subform and then entering new data.

I therefore want to look this table so only one row can exist.
 
set the subform's AllowAdditions property to No, and keep AllowEdits as Yes.
suggest you also set the AllowDeletions property to No.

hth
 
Back
Top