Look-Up a Related record in another form

[Guest]

(A) I have 1000 clients in a client table, with an autonumber primary key for
each client. A form is designed for Input purposes with the table.Call it
Form A
(B) A second table holds a related set of transaction information about the
client , including a look-up to the client ID in the first table.
(C) A query allows extraction of Client DAta and transaction data, which may
be viewed through a form , call it form B.

My problem is as follows:

When I am looking at clients in form A, I may want to look at form B to see
the same client and his/her transaction.

I have tried a button from the wizard with unsuccesful attempts at VB script
to get me to the matched record. I feel that this is the routre to go but am
stuck.

Anybody out there able to steer me to destination ??

Thanks in anticipation

 

[Joan Wild]

When I am looking at clients in form A, I may want to look at form B
to see the same client and his/her transaction.

I have tried a button from the wizard with unsuccesful attempts at VB
script to get me to the matched record. I feel that this is the
routre to go but am stuck.

This is normally accomplished by using a form for the client table, and a
subform for the transaction table. If you've established a relationship
between these two tables, the wizard will create it for you.

At the first step in the wizard, select your client table and its fields,
and then select your transaction table and the fields you want. You'll see
that the wizard makes the connection between the two, and offers to create a
form with a subform.