I'm Blanking Bigtime

[Michelle]

Hey all, this should be simple but I must be overthinking it. I have two
combo boxes on my database that pull from a table containing "Class Title"
and "Instructor". When someone selects a certain "Class Title" the
"Instructor" name automatically populates in the Instructor combo box. This
works great.

However one of my classes (Class title - "5S") has 7 different "instructors"
listed. Each "instructor" is listed on a separate line in the table. When I
choose "5S" as the class it automatically fills in the first instructor I
have listed, even if I choose another instructor.

I would like the option of choosing any of the 7 "Instructors" for the "5"
class title. Any thoughts? If I haven't included enough information, please
let me know. Thanks.

 

[Ken Snell \(MVP\)]

You likely need to change the Row Source query for that Instructor combo
box. Can you post what the current Row Source property is for that combo
box? (Note: if it's the name of a query, please post the SQL statement of
that query.)

 

[Michelle]

Right now the rowsource is a query (sorry I think I said table below). The
SQL is

SELECT [List of Classes and Instructors].Instructor, [List of Classes and
Instructors].Classes
FROM [List of Classes and Instructors];

 

[Ken Snell \(MVP\)]

In order for that second combo box to "fill in" with the instructor after
you make a selection in the first combo box, normally one would see a WHERE
clause in the Row Source query for the second combo box. I don't see that
here.

What is the Row Source query statement for the first combo box? And do you
run any programming (macro or VBA code) on the AfterUpdate or Change or
Click event of that first combo box -- and if yes, post that code.

--

Ken Snell
<MS ACCESS MVP>

Right now the rowsource is a query (sorry I think I said table below).
The
SQL is

SELECT [List of Classes and Instructors].Instructor, [List of Classes and
Instructors].Classes
FROM [List of Classes and Instructors];

You likely need to change the Row Source query for that Instructor combo
box. Can you post what the current Row Source property is for that combo
box? (Note: if it's the name of a query, please post the SQL statement of
that query.)

 

[Michelle]

The rowsource query for the first combo box is "List of Classes Query" (SQL
below) I have set the column count to 2, bound column 1. When the user
clicks on the "Classes" combo box they see both the "class" and "instructor"
Whatever class they click on fills the "Class" combo box and the "Instructor"
box automatically populates. If there's a better way to do this, I'm all for
it.

The SQL for the classes box is:

SELECT [List of Classes and Instructors].Classes, [List of Classes and
Instructors].Instructor
FROM [List of Classes and Instructors];

I'm kinda flying by the seat of my pants...could you tell? HA

In order for that second combo box to "fill in" with the instructor after
you make a selection in the first combo box, normally one would see a WHERE
clause in the Row Source query for the second combo box. I don't see that
here.

What is the Row Source query statement for the first combo box? And do you
run any programming (macro or VBA code) on the AfterUpdate or Change or
Click event of that first combo box -- and if yes, post that code.

--

Ken Snell
<MS ACCESS MVP>

Right now the rowsource is a query (sorry I think I said table below).
The
SQL is

SELECT [List of Classes and Instructors].Instructor, [List of Classes and
Instructors].Classes
FROM [List of Classes and Instructors];

You likely need to change the Row Source query for that Instructor combo
box. Can you post what the current Row Source property is for that combo
box? (Note: if it's the name of a query, please post the SQL statement of
that query.)

--

Ken Snell
<MS ACCESS MVP>


Hey all, this should be simple but I must be overthinking it. I have
two
combo boxes on my database that pull from a table containing "Class
Title"
and "Instructor". When someone selects a certain "Class Title" the
"Instructor" name automatically populates in the Instructor combo box.
This
works great.

However one of my classes (Class title - "5S") has 7 different
"instructors"
listed. Each "instructor" is listed on a separate line in the table.
When I
choose "5S" as the class it automatically fills in the first instructor
I
have listed, even if I choose another instructor.

I would like the option of choosing any of the 7 "Instructors" for the
"5"
class title. Any thoughts? If I haven't included enough information,
please
let me know. Thanks.

 

[Ken Snell \(MVP\)]

What is the Control Source property for the first combo box? And for the
second combo box? Is the form a continuous forms view, or single forms view?
Are both combo boxes located in the Detail section of the form -- if not, in
which section? And are both in the same section? Do you have a subform
involved on your form?
--

Ken Snell
<MS ACCESS MVP>

The rowsource query for the first combo box is "List of Classes Query"
(SQL
below) I have set the column count to 2, bound column 1. When the user
clicks on the "Classes" combo box they see both the "class" and
"instructor"
Whatever class they click on fills the "Class" combo box and the
"Instructor"
box automatically populates. If there's a better way to do this, I'm all
for
it.

The SQL for the classes box is:

SELECT [List of Classes and Instructors].Classes, [List of Classes and
Instructors].Instructor
FROM [List of Classes and Instructors];

I'm kinda flying by the seat of my pants...could you tell? HA

In order for that second combo box to "fill in" with the instructor after
you make a selection in the first combo box, normally one would see a
WHERE
clause in the Row Source query for the second combo box. I don't see that
here.

What is the Row Source query statement for the first combo box? And do
you
run any programming (macro or VBA code) on the AfterUpdate or Change or
Click event of that first combo box -- and if yes, post that code.

--

Ken Snell
<MS ACCESS MVP>

Right now the rowsource is a query (sorry I think I said table below).
The
SQL is

SELECT [List of Classes and Instructors].Instructor, [List of Classes
and
Instructors].Classes
FROM [List of Classes and Instructors];


:

You likely need to change the Row Source query for that Instructor
combo
box. Can you post what the current Row Source property is for that
combo
box? (Note: if it's the name of a query, please post the SQL statement
of
that query.)

--

Ken Snell
<MS ACCESS MVP>


Hey all, this should be simple but I must be overthinking it. I
have
two
combo boxes on my database that pull from a table containing "Class
Title"
and "Instructor". When someone selects a certain "Class Title" the
"Instructor" name automatically populates in the Instructor combo
box.
This
works great.

However one of my classes (Class title - "5S") has 7 different
"instructors"
listed. Each "instructor" is listed on a separate line in the
table.
When I
choose "5S" as the class it automatically fills in the first
instructor
I
have listed, even if I choose another instructor.

I would like the option of choosing any of the 7 "Instructors" for
the
"5"
class title. Any thoughts? If I haven't included enough
information,
please
let me know. Thanks.