Combine two field contents to one variable

[8441]

I have two fields on a form. Duty_Name and Duty__Location. I want to combine the contents of both of these fields (text) into a variable called DutyDetails. I will then insert DutyDetails into a seperate table from the one that the form is linked to called Vehicle Booking.

I can do the insert part but I can't think of a way of combining the contents of these two fields to the one variable in my code.

Has anyone any ideas? Help greatly appreciated.

Craig

 

[jrbarnett]

Hi,

You can use the ampersand symbol & to concatenate strings together in code.

Thus:
DutyDetails = DutyName & " " & DutyLocation

John

 

[8441]

Exactly what i need.

Many thanks.

craig