Concatenate Variables

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there a way to concatenate a variable as part of a form caption.

eg.
me.caption=forms.frmPat.txtname & variablename

Please help
Thanks
 
yes

strName = "This is a variable"
Me.Caption = Forms!frmVar!txtVar.Value & " " & strName

This assumes that frmVar is a separate form in which a value is entered

HTH
 
Back
Top