Getting Query Values for a Form

[JoeTekTips]

Hello,
I am still stuck on this one;

For a form that creates a job ticket, I need to get values from a query and assign those values to certain applicable text boxes. One query value is based on the currently selected value in a combo box (cboCustomer).

I had a suggestion in another thread to display the query results in the combo box, which is easy enough to do, but the idea is to obtain the customer address when that a customer is selected and then populate the shipto textbox fields with those values. This way, if the order is shipping to a differant location, the user can just type over the values.

I can get the values and display them as columns in the combo box, but as mentioned, that is not what I really want to do. I am wondering if there is a way through VBA to get the query results from the combo box.

Thanks in advance for any help,
-Joe

 

[PHV]

Have a look at the Column property of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886