By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,442 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

Linking two fields

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Dear Pharah,

To start go to access help and lookup "concatenation"

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@Canon via AccessMonster.com"" <fo***@AccessMonster.com> wrote in
message news:50***********@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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.