Query result to Text box

[northernbreaks]

Hi
I have a query with 2 fields, when it is run it returns a result based upon the result of the set criteria.

Can you get this value to be displayed in a text box after a button is pressed.

dave

 

[reclusivemonkey]

Yes you can. You will need to trigger it in someway though, (i.e. in a form). In which case you may as well simply add it to a form?

 

[northernbreaks]

query and text box

Hi
I have added a button to a form, but cannot figure out how to move the query result into a text box by just pressing a button.


Dave

 

[reclusivemonkey]

Use VBA. I take it you are not familiar with this? If you search the forum for Recordsets, you will find many examples of getting results from a query. It should be fairly straighforward to get this into a string and then output via a textbox.