A
Antonio
I have a form where the user updates information in fields on a form that is
set to Continuous Forms to mimic a data sheet. When it is necessary to add
additional information, the user clicks a button that opens a seperate form
for additional info that is not a part of every record.
Example
Two tables, tblone, tbltwo.
Two forms, frmRequest (continuous forms mimicking a datasheet), frmDayApproval
On frmRequest, Record 1 has data fields a, b, c, d filled in and are all
stored on tblone.
On frmRequest, Record 2 has data fileds a, b, c, d filled in and are also
stored on tblone.
However, Record 2 has additional qualifications. So, the user opens
frmDayApproval where he/she fills in fields e, f, g that are stored on tbltwo
(the records in the two tables are linked by a unique account number in the
following format "VXXXXXXX" where X is any combination of numbers...this
field gets filled in on the before insert event of frmDayApproval).
The idea was to avoid loads of empty data fields for many of the records in
a table.
I would like the focus to remain on the initial record on frmRequest after
the user closes frmDayApproval. Right now, on the "on close" event of
frmDayApproval, I requery frmRequest to re fire some conditional formatting
to show the user what he/she just updated. The requerying re sets the focus
to the first record on the form (could be 50 to 100 records on form at one
time). This makes it necessary for the user to scroll to find the record they
were just working on.
Can the GoToRecord function be used on the "on close" event of
frmDayApproval to send the user back to the record they were using after the
form is requeried?
Am I going about this in all the wrong manner?
TIA
Antonio
set to Continuous Forms to mimic a data sheet. When it is necessary to add
additional information, the user clicks a button that opens a seperate form
for additional info that is not a part of every record.
Example
Two tables, tblone, tbltwo.
Two forms, frmRequest (continuous forms mimicking a datasheet), frmDayApproval
On frmRequest, Record 1 has data fields a, b, c, d filled in and are all
stored on tblone.
On frmRequest, Record 2 has data fileds a, b, c, d filled in and are also
stored on tblone.
However, Record 2 has additional qualifications. So, the user opens
frmDayApproval where he/she fills in fields e, f, g that are stored on tbltwo
(the records in the two tables are linked by a unique account number in the
following format "VXXXXXXX" where X is any combination of numbers...this
field gets filled in on the before insert event of frmDayApproval).
The idea was to avoid loads of empty data fields for many of the records in
a table.
I would like the focus to remain on the initial record on frmRequest after
the user closes frmDayApproval. Right now, on the "on close" event of
frmDayApproval, I requery frmRequest to re fire some conditional formatting
to show the user what he/she just updated. The requerying re sets the focus
to the first record on the form (could be 50 to 100 records on form at one
time). This makes it necessary for the user to scroll to find the record they
were just working on.
Can the GoToRecord function be used on the "on close" event of
frmDayApproval to send the user back to the record they were using after the
form is requeried?
Am I going about this in all the wrong manner?
TIA
Antonio