If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form linked to table help
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. |
#2
|
|||
|
|||
Form linked to table help
set the subform's AllowAdditions property to No, and keep AllowEdits as Yes.
suggest you also set the AllowDeletions property to No. hth "Andy" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|