Refresh 1st form?

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.
 
B

BruceM

What is the btnTransactions code? Is there a connection between the form
called up by btnTransactions and the Client? I know you said you are using
ClientID from frmClient as the "default FK" for the transaction, but that's
hard to follow. What I am getting so far is that you click a button on
frmClient to open a Transaction form, on which you click another button to
bring you to a form for a particular type of transaction. What I don't see
is how all of the parts fit together.

Typically you would have a main form for the client, with subforms based on
related tables. The Link Child and Link Master properties of the subform
controls are what establish the link between the records entered in the
related tables via the subforms and the main client record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top