If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform parameter query
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 |
#2
|
|||
|
|||
Subform parameter query
Just wanted to add that 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. |
Thread Tools | |
Display Modes | |
|
|