How to use DAO to autofill values after a combo box selection

[Tyskie19]

I am extremely knew to VB so I need a bit of a push in the right direction.

I have an order form, and this order form has various customer information. What I want to do is in the header have a combo box for the order number, so that upon selecting the order the rest of the information will pop up in the detail section. How do I do this using DAO?

 

[PHV]

Why not simply follow the ComboBox wizard (3rd option) ?

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

 

[Tyskie19]

that works, but i can't get it to populate the unbound fields (if that's possible) or the bound fields in the subform

 

[Tyskie19]

ahhh nevermind i think i've got it now, can't believe it was so simple, thx man