Form linked to table help

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.
 
T

tina

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
First Subform record gets modified when closing form 3
Form/Subform with Parameter 2
Can't save record 4
Main Form with Subforms 5
Writting two subforms to the same table. 9
My input form isn't empty? 5

Top