2 Fields into 1

[AndyShuter]

Just wonering if there is a way I can mush 2 fileds into 1 when an event occurs,

for example

when I click a command button I would like the 2 fields RepForeName & RepSurname to appear in the text field Last User

Ayyyyyyy Thank u!

 

[trucktime]

Fields

In the Control Source of the field LastUser put:

=[RepForeName] &" "&[RepLastname]

No need for a button here.

However, if you want to use a button you can put this
in the OnClick Event:

Me.Lastuser = [RepForeName] &" "&[RepLastname]

 

[AndyShuter]

Thanks

Thanks Amigo

 

[trucktime]

Great

You're welcome.