Linking two fields

[\Pharah@Canon via AccessMonster.com\]

Hi. It's me again. Just wanted to know: How do you join two fields together?


I mean if you enter Field 1 (i.e. Sales Executive) Field 2 (i.e His/Her
Manager) automatically populates? Can you tell me how that's done (step-by-
step, since I am new to this)?

Thanks in advance.

Pharah

--
Message posted via http://www.accessmonster.com

[Barry Edmund Wright]

Re: Linking two fields


Dear Pharah,

To start go to access help and lookup "concatenat ion"

Example: If you have a form with three text boxes named:
FirstName (the control source is strFirstName)
LastName (the control source is strLastName)
FullName (see below to find out how to add control source)

You want to populate the field FullName with FirstName and LastName then
put if the recordsource (right-click on FullName field, select properties
then for Control Source enter "=[FirstName] & " " & [LastName]

Regards,
Barry

""Pharah@Ca non via AccessMonster.c om"" <forum@AccessMo nster.com> wrote in
message news:50EC0AE518 217@AccessMonst er.com...
Hi. It's me again. Just wanted to know: How do you join two fields
together?


I mean if you enter Field 1 (i.e. Sales Executive) Field 2 (i.e His/Her
Manager) automatically populates? Can you tell me how that's done (step-by-
step, since I am new to this)?

Thanks in advance.

Pharah

--
Message posted via http://www.accessmonster.com