C
connie
I am working with a table called T_Actions. Linked to another table called
T_CaseNbr by the field CaseNbr.
SF_Actions is a datasheet subform on the form F_CaseNbr using the CaseNbr as
Child/Master link.
For each CaseNbr, there are many Actions.
When someone inputs a record in the Actions SubForm, filling in the
different fields – one of the fields is in password format, and it is called
SupvAprvl.
Since the Supervisor will be approving many Actions input by other people,
is there a way to run an update that when the field, SupvAprvl is not null,
the Supervisor’s password would be filled in on the rest of the records for
the same CaseNbr? That way the Supervisor would only have to type their
approval once.
An example:
8/10/05 …..PA….[SupvAprvl]…..xxxx……xxxxx
8/11/05……PR…[*******] …..xxxx…….xxxxx
In the above example, once the supervisor fills in the password (*****), the
[SupvAprvl] on 8/10/05, should be updated with the same ****** IF IT IS
NULL. (Another Supervisor may have already approved that record.)
I thought an update query to be run on the LostFocus Event of the
Supv.Aprvl field.might work, but I’m not sure an update query could be run
with the record still open. I think it will have to be called when the form
moves to a new CaseNbr Record. and leaves the SubForm, SF_Actions.
Can someone help with the correct syntax to run this or a better suggestion
so that the Supervisor doesn’t have to type their password 20 or more times
on each record line to approve all the Actions for a CaseNbr.
Thanks in Advance,
Connie
T_CaseNbr by the field CaseNbr.
SF_Actions is a datasheet subform on the form F_CaseNbr using the CaseNbr as
Child/Master link.
For each CaseNbr, there are many Actions.
When someone inputs a record in the Actions SubForm, filling in the
different fields – one of the fields is in password format, and it is called
SupvAprvl.
Since the Supervisor will be approving many Actions input by other people,
is there a way to run an update that when the field, SupvAprvl is not null,
the Supervisor’s password would be filled in on the rest of the records for
the same CaseNbr? That way the Supervisor would only have to type their
approval once.
An example:
8/10/05 …..PA….[SupvAprvl]…..xxxx……xxxxx
8/11/05……PR…[*******] …..xxxx…….xxxxx
In the above example, once the supervisor fills in the password (*****), the
[SupvAprvl] on 8/10/05, should be updated with the same ****** IF IT IS
NULL. (Another Supervisor may have already approved that record.)
I thought an update query to be run on the LostFocus Event of the
Supv.Aprvl field.might work, but I’m not sure an update query could be run
with the record still open. I think it will have to be called when the form
moves to a new CaseNbr Record. and leaves the SubForm, SF_Actions.
Can someone help with the correct syntax to run this or a better suggestion
so that the Supervisor doesn’t have to type their password 20 or more times
on each record line to approve all the Actions for a CaseNbr.
Thanks in Advance,
Connie