Text Box Queries

[fernin8r]

I tried searching this but I couldn't get the search to work.

I would like to set the control source of a text box to a SELECT query. Is this possible? If so, what's the proper syntax?

Thanks,
Mike

 

[FoFa]

you most likely want DLOOKUP or some other Dfunction.
What are you trying to do?
How many values are you trying to look up?

 

[fernin8r]

I'm just trying to run a calculation.

Right now I have set up some VB code to run the calculation and set the text box value. The only problem is getting the value to refresh when I make a change. Just thought there was an easier way.

I will look into the DLookup function.

Thanks.

 

[FoFa]

If you have code to do this already, then you do not need to change it. What you need to do is when a change occurs, you need to refresh (controlname.requery) the text box.
Of course this means you have to detect the change.
Same would hold true with Dlookup.