473,320 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Text box linked to combo box

Les
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
?

Nov 13 '05 #1
3 2417
Jan
Les wrote:
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 ?

LEt's step back a bit and consider changing your structure a little.

Create a 3rd table, tblEmployeeGrp
EGrpID
EmployeeID
GroupID

For each group that an employee is part of, you have one record in this
3rd table. That way if the employee is only part of one group there's
just one record; if they're part of 10 groups, you can accommodate it.
(Oh, and by the way, you'd then remove those group1 to group5 fiels in
tbleEmployees.)

Now, for your form, you 'll have a master form based on tblEmployees,
and then a subform based on tblEmployeeGroup. The subform will be
driven by a query, which will include tblemployeeGrp and tblGroups.
You'll pull the Description from tblGroups, the other stuff from
tblEmployeeGrp.

I hope this helps. There's a lot of concept here, about forms and
subforms, related tables, queries, etc. You'll have to look in Help, or
at the sample databases, or get an Access book if you want to pursue the
details.

Good luck.
Nov 13 '05 #2
Thanks for the help, will try

Tempy

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3
Tempy <an*******@devdex.com> wrote in news:jS***************@news.uswest.net:
Thanks for the help, will try

Tempy

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


I have kill filed this poster and plan to (when I remember) kill file all
Developersdex posters.
I very much dislike posts which have nothing of the previous post included.
And I resent the commercial exploitation of this group by a website which
uses our answers as bait for advertising.

I am sure Developersdex users will get adequate answers from others; they
just won't get them from me.

--
Lyle
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Neil | last post by:
I previously posted re. this, but thought I'd try again with a summary of facts. I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that is linked to the database via ODBC...
3
by: MS | last post by:
What's the best way to "store" and display a value in a text box that changes from day to day. An example of this would be where the name of the user is manually typed in after using the datbase,...
2
by: Tempy | last post by:
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...
2
by: Shannan Casteel via AccessMonster.com | last post by:
I have a table with information about different people...(i.e. Name, Address, Phone, Fax, etc.). The table has been linked to Access. I have created a combo box that uses this information. ...
5
by: CCLeasing | last post by:
Hello, I have searched google but can not find a straight forward answer to my problem. Hopefuly someone will be kind enough to offer their expertise. Please forgive if this seems a bit convoluted...
0
by: CCLeasing | last post by:
Hello, I have searched google but can not find a straight forward answer to my problem. Hopefuly someone will be kind enough to offer their expertise. Please forgive if this seems a bit convoluted...
1
by: technocraze | last post by:
Hi guys, I am having trouble resolving this error. Below mentioned is my code and implmentation. MS Acess is my front end and sql server is my backend. What i want to achieve is to be...
6
by: zuchowra | last post by:
Hi everyone. I need help. I have a combo box in my form that i want to populate multiple text boxes after you select your selection in the combo box. Here is my set up. The Fields that need to be...
4
by: shreyansghia | last post by:
Hello , I ve a form which is based on a table viz SalesOrder. 1 of the field which Sales Order has is : Client. I ve 2 more tables, (a) Client which has 1 field viz ClientName , (b)...
9
by: Marianne160 | last post by:
Hi, I know there are various answers to this problem available on the web but none of them seem to work for me. I am using Access 2003 to make a form to look up data from a table. I have so far...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.