Simple syntax in a form

[Guest]

Can you provide me with the correct expression to show data in one form onto
another form? The expression would be typed in the Control Source of "Form A"
and the data viewed is in Form B:

IF FormA ClientID = FormB ClientID show FormB, field [ArtCompleted]

I tried the following and it doesn't work (don't know how to have ClientID =
ClientID and can't have a subform as FormA as to remain a continuous form)

=[FormB]![ArtCompleted]

THANK YOU

 

[Guest]

To get a value from another form
=Forms![FormName]![FieldName]

To get a value from a subform
=Forms![FormName]![SubFormName].Form![FieldName]

 

[Guest]

That part works but how do I link to the main form by clientId again without
inserting a subform?

To get a value from another form
=Forms![FormName]![FieldName]

To get a value from a subform
=Forms![FormName]![SubFormName].Form![FieldName]

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck

Can you provide me with the correct expression to show data in one form onto
another form? The expression would be typed in the Control Source of "Form A"
and the data viewed is in Form B:

IF FormA ClientID = FormB ClientID show FormB, field [ArtCompleted]

I tried the following and it doesn't work (don't know how to have ClientID =
ClientID and can't have a subform as FormA as to remain a continuous form)

=[FormB]![ArtCompleted]

THANK YOU