Combo box triggers value to appear on next field

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

I have a form called Classes with a combo box that lookups Instructor
data from a second linked table. This feature works fine and there are
no events associated with it.

The next field in the form is also a combo box based on a yes/no field.
Once I select the Instructor in the first combo box, it triggers the
next combo box to display a value of no. This second combo box has no
default set in the table or the form and I do not want one. If I change
the second combo box to use an option group instead, the same behavior
still occurs. After choosing the Instructor in the first combo box, the
option group gets automatically set to a value of no.

Does anyone know what is causing this and how I stop it? I am wondering
if the problem is related to using a Boolean field instead of a text
field. I wanted to stay with the Boolean option but can switch to a
text field if necessary.
 
JB said:
I have a form called Classes with a combo box that lookups Instructor
data from a second linked table. This feature works fine and there are
no events associated with it.

The next field in the form is also a combo box based on a yes/no field.
Once I select the Instructor in the first combo box, it triggers the
next combo box to display a value of no. This second combo box has no
default set in the table or the form and I do not want one. If I change
the second combo box to use an option group instead, the same behavior
still occurs. After choosing the Instructor in the first combo box, the
option group gets automatically set to a value of no.

Does anyone know what is causing this and how I stop it? I am wondering
if the problem is related to using a Boolean field instead of a text
field. I wanted to stay with the Boolean option but can switch to a
text field if necessary.
Click to expand...


If I am reading you right, once you select the instructor name in the first
combo box, Access goes to that record of your linked table.
Then the 2nd combo box or option group takes on the value of the associated
yes/no field of that instructor's record in your linked table (which happens
to be "No". Try changing the instructor's yes/no field value to "Yes" in
your table and see if the 2nd control assumes a "Yes" value to confirm this.

If the table's yes/no field is listed as your Control Source in the 2nd
control's property sheet, this is how it should work.


--
 
Back
Top