Dynamically Loading Query Results

[parth00]

Hi All,
I am new to Access and looking for some help.

I have a query, which reads the combo box value and loads the result in Text box. It works fine when I load the Form.
Now here is the problem… If I select another values from combo box the query result remains the same (in text box). How do I make it work dynamically?
So when I select new value in combo box, the resulting query gets updated in textbox.

Thanks

 

[RuralGuy]

I believe all you need do is Me.Requery in the AfterUpdate event of the ComboBox if your form is bound to the query.

 

[parth00]

Form is not bound to the query.. Only Textbox is connected to Query...

 

[RuralGuy]

What are you doing when the form loads that runs the query and fills the textbox?