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

Text box linked to Combo Box

P: n/a
Good day,
I am new to Access and need a question answered please.
I have a form based on a table (tblQualityEmployees), for some of the
fields it looks up a value in another table (tblGroups).
The tblQualityEmployees consists of the following:
EmployeeID
FirstName
LastName
Group1
Group2
Group3
Group4
Group5
The tblGroups consists of the following:
GroupID
Groups
Description
What i want to do is, in the form have text box that displays the Group
description next to each group. I tried making the "Control Source"
field Group1 combo. This brings in the relevant ID number which is
fine, but i want to see the discription which is in field 3 and not
field 1.
Is this possible or must i also have the description in the first table
?


Tempy

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
This article tells you how to show the other columns of a combo box in
textboxes:
http://www.mvps.org/access/forms/frm0058.htm

--

Ken Snell
<MS ACCESS MVP>
"Tempy" <an*******@devdex.com> wrote in message
news:Z2*************@news.uswest.net...
Good day,
I am new to Access and need a question answered please.
I have a form based on a table (tblQualityEmployees), for some of the
fields it looks up a value in another table (tblGroups).
The tblQualityEmployees consists of the following:
EmployeeID
FirstName
LastName
Group1
Group2
Group3
Group4
Group5
The tblGroups consists of the following:
GroupID
Groups
Description
What i want to do is, in the form have text box that displays the Group
description next to each group. I tried making the "Control Source"
field Group1 combo. This brings in the relevant ID number which is
fine, but i want to see the discription which is in field 3 and not
field 1.
Is this possible or must i also have the description in the first table
?


Tempy

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #2

P: n/a
Thanks Ken,

I have been on the web and bumped into it, tried it and it works 100%.

thanks very much

Tempy

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.