Forms Linking Question

[Guest]

I have created one table with all the fields i need with 3 separate forms.

on form one i have "client id" "last name" "first name" and fields 4-15.
on form two i have "client id" "last name" "first name" and fields 16-37.
on form three i have "client id" "last name" "first name" and fields 38-67.

if i enter a clients last and first name on form one the information is
correct, when i switch to form two or three the information is for a
different client.

if i check the table the information is being saved correctly.

the question is how do i get the information on form two and three to link
to form one when i change the client name?

i hope i provided enough info. please let me know if i didn't.

thanks

 

[Guest]

Difficult to do as you would need to refresh or requery the other forms.

Try using one form with tabs.