M
Margaret Bartley
Access 2003:
This combobox is a list of all the teachers, and also displays the number of
children, and the number of families assigned to each teacher. Some
children do not have a teacher assigned yet.
The drop-down list, and the query it is based upon, correctly displays a
null in the Teacher column, and the correct count of children and families
in columns(1) and (2).
However, when I look at the value of cboTeachers.Column(1) or
cboTeachers.Column(2) in the Immediate window, the Locals window, or passed
in a Message Box, they all show up as null values.
I'd like to get a count of the children who do not have teachers in the
AfterUpdate event of this combobox.
What's going on, please?
This combobox is a list of all the teachers, and also displays the number of
children, and the number of families assigned to each teacher. Some
children do not have a teacher assigned yet.
The drop-down list, and the query it is based upon, correctly displays a
null in the Teacher column, and the correct count of children and families
in columns(1) and (2).
However, when I look at the value of cboTeachers.Column(1) or
cboTeachers.Column(2) in the Immediate window, the Locals window, or passed
in a Message Box, they all show up as null values.
I'd like to get a count of the children who do not have teachers in the
AfterUpdate event of this combobox.
What's going on, please?