N
naigy via AccessMonster.com
Hi I have a form that is used for entering service details for a unit. The
main form is used for entering unit serial number, service date etc. Sub1 is
used for parts required to service unit and Sub2 is used for additional
services Performed. This Sub2 is the field I have a problem with.
Now my problem is if I am viewing the most recent record and click create new
record from the record selector at the bottom of the form Sub2 data does not
clear itself. Instead it still holds the data of the previous record. However
on my switchboard I have a button which opens this main form in add mode and
it opens with Sub2 data blank. Sub2 is linked to the main form with 2 fields
(Servicedate & SerialNumber).
Any help on how to clear the data in Sub2 when new record is created using
nav buttons would be appreciated. Thanks.
main form is used for entering unit serial number, service date etc. Sub1 is
used for parts required to service unit and Sub2 is used for additional
services Performed. This Sub2 is the field I have a problem with.
Now my problem is if I am viewing the most recent record and click create new
record from the record selector at the bottom of the form Sub2 data does not
clear itself. Instead it still holds the data of the previous record. However
on my switchboard I have a button which opens this main form in add mode and
it opens with Sub2 data blank. Sub2 is linked to the main form with 2 fields
(Servicedate & SerialNumber).
Any help on how to clear the data in Sub2 when new record is created using
nav buttons would be appreciated. Thanks.