Desperate for help

[drider629]

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. Both controls are
bound to different fields on
the same table which are part of a one to many relationship between
the main form and subform. I would appreciate
anyone that could shed some light on this for me... Thanks

 

[Guest]

It would seem to me that you could use dlookup to get the value from the
query you use to populate your first combo box.

1. Assume your cbo uses query1 to return an ID (bound, but hidden) and some
other text value

2. Then in the after update of that combo, you need to put something like:

Private sub cbo_afterUpdate

Dim strCriteria as string

strCriteria = "ID <> " & me.cbo.value
me.yourTextbox = DLOOKUP("FieldName", "query1", strCriteria)

End sub

HTH
Dale