Simple syntax in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
To get a value from another form
=Forms![FormName]![FieldName]

To get a value from a subform
=Forms![FormName]![SubFormName].Form![FieldName]
 
That part works but how do I link to the main form by clientId again without
inserting a subform?

Ofer said:
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



VAL said:
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
Click to expand...
Click to expand...
 
Back
Top