Click event for combo box

[torifan]

I've got a combo box that has a part number and description from a table. I need to have a click event for that combo box that will pull the corresponding selling price information into another text box. I've had experience with VB, but not VBA. Can anyone help me get started on this?

 

[jmersing]

You may just want to use the ComboBox Wiard, and select the option "Find a record on my form based on the value I choose"

Then have a text box with the control source set to the field you want to display for that record. You could then look at the code generated by the Wizard to help you understand.

HTH
Jim

 

[torifan]

Hey Jim,

Thanks for your response. I had gotten another response on another board and got the problem straightened out. Now, on to the next problem. LOL

Amy