Join/Merge/Blend "Text" & [Field_Name]

[Alan Forman]

Hi Guys

I'm trying to join 2 bits of info together to set data in a field.

The first part is the field name which always starts with the text "Name_", the second part is a variable field name (which is actually a time slot).

I've done ...

If "Me.Name_" & [Temp_Time_Slot] <> "" Then ..........

Which seems to work, but I want to have after that ....

"Name_ " & [Temp_Time_Slot] = Me.Temp_Name

Which doesn't.

Do I need to Dim as String ?

Any ideas, thank you in advance

Alan

:banghead:

 

[pbaldy]

Try

Me("Name_" & [Temp_Time_Slot])

 

[Alan Forman]

Thank you pbaldy.

Worked a charm.

Thanks again.

 

[pbaldy]

Happy to help!