H
Hey
I have a client form (frmClient) that has a button on it called
btnTransactions. When clicked, it calls up a form where my user can choose
what type of transaction to put in for that client (purchase/cash
payment/credit adjustment, etc so frmPurchase, frmPayment,frmAdjustment).
Depending on which button is clicked on, a form is displayed to add that
appropriate transaction. I use =([Forms]![frmClient]![ClientID]) as the
default fk clientID on this transaction screen (whichever one is chosen).
And that ties the transactions to the client.
I have one user who switches back and forth between clients alot, and
doesn't want to have to exit back to that first client screen in order to
choose the next client with which to work. She mostly does one type of
transaction only so the middle form isn't really needed in her case (and
maybe with others as well--but just sometimes for everyone else).
I know I can pop up a new form to choose a client, but how do I get it to
update that 1st client form without closing the 2 open forms that come after
the client is chosen.
Understand what I need? Is there some way to change the active record on an
underlying form without going to it specifically?
Thanks for any help.
btnTransactions. When clicked, it calls up a form where my user can choose
what type of transaction to put in for that client (purchase/cash
payment/credit adjustment, etc so frmPurchase, frmPayment,frmAdjustment).
Depending on which button is clicked on, a form is displayed to add that
appropriate transaction. I use =([Forms]![frmClient]![ClientID]) as the
default fk clientID on this transaction screen (whichever one is chosen).
And that ties the transactions to the client.
I have one user who switches back and forth between clients alot, and
doesn't want to have to exit back to that first client screen in order to
choose the next client with which to work. She mostly does one type of
transaction only so the middle form isn't really needed in her case (and
maybe with others as well--but just sometimes for everyone else).
I know I can pop up a new form to choose a client, but how do I get it to
update that 1st client form without closing the 2 open forms that come after
the client is chosen.
Understand what I need? Is there some way to change the active record on an
underlying form without going to it specifically?
Thanks for any help.