G
Guest
I have a continuous form called “Ledger Transactions to be deleted†that
displays one or more transactions for a given client.
The user can set a flag on a selected transaction to denote that the
transaction is to be marked for deletion.
I want the system to attach the name of the user to the transaction.
The username is a field on the transaction record and is on the “Ledger
Transactions to be deleted" form, but is not visible.
The username is recorded on a form called "Welcome Menu".
I assume I could use the Setvalue action to populate the username field on
Delete Transaction i.e. [Forms]![Ledger Transactions to be
deleted]![Username], [Forms]![Welcome Menu]![Username]
However, where should I put the Setvalue Action? I tried putting the
Setvalue Action
on the Gotfocus event on the Username field, but this does not seem to work.
Secondly I have a table called Username, which holds a single record
containing the username. This record is changed when the user enters his/her
name on the Welcome Menu.
I would prefer to add the username to the [Forms]![Ledger Transactions to be
deleted]![Username] field by accessing the Username table, rather than
leaving the Welcome Menu open. How could this be done?
displays one or more transactions for a given client.
The user can set a flag on a selected transaction to denote that the
transaction is to be marked for deletion.
I want the system to attach the name of the user to the transaction.
The username is a field on the transaction record and is on the “Ledger
Transactions to be deleted" form, but is not visible.
The username is recorded on a form called "Welcome Menu".
I assume I could use the Setvalue action to populate the username field on
Delete Transaction i.e. [Forms]![Ledger Transactions to be
deleted]![Username], [Forms]![Welcome Menu]![Username]
However, where should I put the Setvalue Action? I tried putting the
Setvalue Action
on the Gotfocus event on the Username field, but this does not seem to work.
Secondly I have a table called Username, which holds a single record
containing the username. This record is changed when the user enters his/her
name on the Welcome Menu.
I would prefer to add the username to the [Forms]![Ledger Transactions to be
deleted]![Username] field by accessing the Username table, rather than
leaving the Welcome Menu open. How could this be done?