Field Concatenation

[BradleyJ]

I have a field in a seperate but related frm called Contact Name where I concatenate the FN and LN fields from the previous frm. This is the formula that I am using =Forms!Contacts!FirstName & " " & Forms!Contacts!LastName. Sometimes it works and sometimes it doesn't. Whats up.

 

[Ken Snell]

Is the form open whenever you want the concatenated value to show? If the
Contacts form isn't open, no values can be read.

--
Ken Snell
<MS ACCESS MVP>

I have a field in a seperate but related frm called Contact Name where I

concatenate the FN and LN fields from the previous frm. This is the formula
that I am using =Forms!Contacts!FirstName & " " & Forms!Contacts!LastName.
Sometimes it works and sometimes it doesn't. Whats up.

 

[Van T. Dinh]

The Form "Contacts" must be open for the Calculated Control in the second
Form to work.

--
HTH
Van T. Dinh
MVP (Access)

I have a field in a seperate but related frm called Contact Name where I

concatenate the FN and LN fields from the previous frm. This is the formula
that I am using =Forms!Contacts!FirstName & " " & Forms!Contacts!LastName.
Sometimes it works and sometimes it doesn't. Whats up.