Change Text in Textbox based on Combobox Selection

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.
 
S

Steve

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.
 
S

Steve

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top