D
drider629
There is probably a much better way to do this, and I hope there is,
but here is what I am trying to do: I have two controls on a
"subform" (a combobox and a textbox). I have the row source of the
combo set to the value of a query which gives me two choices. After I
select one of the choices I would like the afterupdate event to fill
in the text box with the remaining choice. I have tried creating a
parameter query that uses the value from the combo box in an criteria
so that the query selects any value that <> the value of the combo.
When I simply run the query it gives me the value I want. However when
I try to set the value of the text box to the query in the after
update event of the combo box, nothing appears. I would appreciate
anyone that could shed some light on this for me... Thanks
but here is what I am trying to do: I have two controls on a
"subform" (a combobox and a textbox). I have the row source of the
combo set to the value of a query which gives me two choices. After I
select one of the choices I would like the afterupdate event to fill
in the text box with the remaining choice. I have tried creating a
parameter query that uses the value from the combo box in an criteria
so that the query selects any value that <> the value of the combo.
When I simply run the query it gives me the value I want. However when
I try to set the value of the text box to the query in the after
update event of the combo box, nothing appears. I would appreciate
anyone that could shed some light on this for me... Thanks