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
select date from list 1
help on my forms and subforms 4
Check for Null in Table 9
Form to show all records from one table, even if no match in anoth 3
Need Mailing and Billing Address Displayed from Same Table 4
First Subform record gets modified when closing form 3
Junction Table IDs via a form 4

Top