Problem with Combo box in subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patty Stoddard - 08 Aug 2005 17:12 GMT

I have a database to track all employee applicants. There are three tables.
tbl #1 "Employee Applicants" :
fields: (1) ApplicantID - Autonumber (2) Name - Text
tbl #2 "Job Skills Categories"
fields (1) SkillID - Autonimber (2) Skill description
tble #3 "Employee Job Skills" - junction table
fields (1) ApplicantID (2) SkillID

I have a form with the fields from the Employee Applicants table and a
subform based on a query of data from tbls "Employee Applicants" and "Job
Skills Category". The subform contains a combo field "Job Field Description"
with row source "Job Skills Category" with 2 columns (one for SkillID and one
for Skill description) bound to column 1. I have the column widths set so I
can see both the SkillID and the Skill Descrption.

The problem is that when I go to the main form and choose another skill from
the drop down menu in the subform, the SkillID displaysinstead of the Skill
Description. Also, it creates a record in the "Job Skills Category" table
instead of the "Employee Job Skills" table.

What am I doing wrong?

Reply to this Message

Duane Hookom - 08 Aug 2005 18:44 GMT

I think you want to bind your subform to table #3. This subform would have a
combo box with a row source based on table #2.

Signature

Duane Hookom
MS Access MVP

>I have a database to track all employee applicants. There are three tables.
> tbl #1 "Employee Applicants" :
[quoted text clipped - 22 lines]
>
> What am I doing wrong?

Reply to this Message

Patty Stoddard - 08 Aug 2005 19:47 GMT

Thank you for your reply. I don't know how to bind my subform to table #3,
but the subform does have a combo box with a row source based on table #2.
What else can I check?

> I think you want to bind your subform to table #3. This subform would have a
> combo box with a row source based on table #2.
[quoted text clipped - 25 lines]
> >
> > What am I doing wrong?

Reply to this Message

Duane Hookom - 08 Aug 2005 20:17 GMT

You stated:
subform based on a query of data from tbls "Employee Applicants" and "Job
Skills Category"

I think your subform should be based on table #3 not tables 1 and 2.

Signature

Duane Hookom
MS Access MVP
--

> Thank you for your reply. I don't know how to bind my subform to table
> #3,
[quoted text clipped - 36 lines]
>> >
>> > What am I doing wrong?

Reply to this Message

Patty Stoddard - 08 Aug 2005 21:28 GMT

Okay. How do I get the Job Skill Description to show up in the drop down
combo box? Table #3 only has the Job SkillID and ApplicantID.

> You stated:
> subform based on a query of data from tbls "Employee Applicants" and "Job
[quoted text clipped - 42 lines]
> >> >
> >> > What am I doing wrong?

Reply to this Message

Patty Stoddard - 08 Aug 2005 21:58 GMT

I've made some progress since your last repy. I based the subform on table
#3 as you suggested. Then in the combo box of the subquery, I indicated
column count = 2 with widths of .2";1" with bound colum #1. This works
great. I can see the skill description from the drop down box and it is
creating a record in table #3 as it should.

It would be better for me if I saw the job skill description instead of the
number after making my choice. How do I accomplish this?

> Okay. How do I get the Job Skill Description to show up in the drop down
> combo box? Table #3 only has the Job SkillID and ApplicantID.
[quoted text clipped - 45 lines]
> > >> >
> > >> > What am I doing wrong?

Reply to this Message

Duane Hookom - 09 Aug 2005 04:59 GMT

If you don't need to ever see the ID, then set the column widths to
0";1"

Signature

Duane Hookom
MS Access MVP

> I've made some progress since your last repy. I based the subform on
> table
[quoted text clipped - 67 lines]
>> > >> >
>> > >> > What am I doing wrong?

Reply to this Message