Data fron 2 different tables on one form

[chemram]

I need my one of my db's forms to have data from 2 different tables on the one form...

eg. The form's record source is TblClients, and it has a button to open another form using the same "ClientID" field as a reference, so if client 12 was on the first form, the new form would open with client 12 also. The problem is , the second form is based on a different table, and even thought the two have a relationship set up between them, it just goes to record 1 all the time. ,,, HELP!?!?!?!?

 

[DH]

If I'm reading the example correctly you could use the Cmd button wizard on your first form and open your second form at specific data(as long as you can match one field from each form.

HTH, I apologise if it doesn't.


David

 

[chemram]

Thanks DH, but i'd already got that far.....no worries though, solved the problem by usin a subform....
Thanks Anyway..

Chemram