J
John MilburySteen
Hi Access Gurus,
I have a form in Access 2000 which helps our department schedule classes.
The form has a combo box which I want to populate with a list of classes
from which to choose. That would be simple, but I want the combo box's pull
down menu to appear with three columns:
ClassName, CountOfRegistrationID (how many students enrolled so far in the
class) and ClassID,
with the third column bound. (ClassID is a meaningless number from the
user's point of view.)
In the row source I specify:
SELECT ClassName, CountOfRegistrationID, ClassID FROM ClassQuery;
ClassQuery is a group query.
This doesn't work. However the following SQL statements work (col. 2
bound):
SELECT ClassName, ClassID FROM ClassQuery;
SELECT CountOfRegistrationID, ClassID FROM ClassQuery;
Are combo boxes limited to two columns?
I have a form in Access 2000 which helps our department schedule classes.
The form has a combo box which I want to populate with a list of classes
from which to choose. That would be simple, but I want the combo box's pull
down menu to appear with three columns:
ClassName, CountOfRegistrationID (how many students enrolled so far in the
class) and ClassID,
with the third column bound. (ClassID is a meaningless number from the
user's point of view.)
In the row source I specify:
SELECT ClassName, CountOfRegistrationID, ClassID FROM ClassQuery;
ClassQuery is a group query.
This doesn't work. However the following SQL statements work (col. 2
bound):
SELECT ClassName, ClassID FROM ClassQuery;
SELECT CountOfRegistrationID, ClassID FROM ClassQuery;
Are combo boxes limited to two columns?