Change Text in Textbox based on Combobox Selection

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am trying to base the text in a Textbox based on a Combobox selection. I
have the value of the combobox tied to a query I built in the query builder.
I can get it to display the first value i select, but it won't do anything
aftet this. I have tried requery commands in VBA but the ones I tried didn't
work. I want it to continuously update based upon the latest selection made
in the combobox. The query being used is a parameter query and the parameter
is the value of the combobox.

Thanks for your help.
 
I got it to requery with a DoCmd.Requery, but now when I change the Combobox,
a parameter entry box pops up asking for the value. It's not recognizing the
value of the Combobox.
 
I figured it out. I tied the On Update of the combobox to a filter which then
fed the Textbox the value I wanted and it works perfectly.
 
Back
Top