L
Larry Kahm
I have a Contacts form that contains, among other fields, a combo box for
Company name and a check box for Currently employed; the latter is set to
true when a new contact record is added to the database.
When the record is updated, and the person no longer works for the company,
the check box is unchecked.
At that point, I'd like to set the value in the Company name combo box to
"(None)" - without the quotes. (None) is a valid company record.
I have tried using:
Me.cboCompanyID = 129
Me.cboCompanyID.Refresh
But I don't think this is doing what I want it to. In any case, the value
in the combo box does not get displayed in the record.
What simple facet of combo box behavior am I missing here?
Thanks!
Larry
Company name and a check box for Currently employed; the latter is set to
true when a new contact record is added to the database.
When the record is updated, and the person no longer works for the company,
the check box is unchecked.
At that point, I'd like to set the value in the Company name combo box to
"(None)" - without the quotes. (None) is a valid company record.
I have tried using:
Me.cboCompanyID = 129
Me.cboCompanyID.Refresh
But I don't think this is doing what I want it to. In any case, the value
in the combo box does not get displayed in the record.
What simple facet of combo box behavior am I missing here?
Thanks!
Larry