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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Linked Combo Boxes with a subform 1
Form Auto Populate 1
Using form and subform not connecting to two separate tables 0
help on my forms and subforms 4
Linking subforms to separate tables 3
Form creates unwanted rows in table 1
Extra lines being added to Table 2
Master/Child Link problem 2

Back
Top