After Update ReQuery and update text box

[Eddy Sincere]

I need to enter a number from a combo box and then have two additional fields update themselves automatically using a query. I'm sure I should be using the After Update event but I can't find anything that shows me the correct code.

The query must be used because I'm also going to use it for other tasks. I could do a (Allen Browne) search form set up, but that seems more complex than I actually need. Is there a simple way to hook the fields up to the query and then update the query once I enter information

Example DB is attached.

Example - After Update Event.zip?

[June7]

Can't reference table or query directly like that in textbox. Would require a DLookup(). However, preferred method is just to reference combobox column index. Index begins with 0.

=[Combo0].[Column](1)

=[Combo0].[Column](2)

This is not updating any fields, just populating unbound textboxes.

[Eddy Sincere]

I thought you were going to say that. I use it on other forms but can't for this example. The problem is I have to use the other 2 fields in the query separate operations which is why I was hoping for an After Update event. If I use the combo box method those fields can't be used for anything other than information.

As always, I appreciate your time and thanks for answering my question. I think I'll just use the search form method.

[June7]

Can certainly have code in AfterUpdate event that sets value of textboxes. Just not understanding why can't use method I suggested.

[Eddy Sincere]

NVM - You are correct. I messed up some of the settings when I was doing the combo box. Your method works perfectly. I originally thought the information was for informational purposes only and I didn't realize you could use it as criteria in a query. Thanks. Problem solved.