Populate Form from Combo Box

[Nick]

Hey guys - I have a relatively straight-forward question that hopefully has a
simply answer:

I have a form based on a table (Call it Table A). Table A has alot of fields
(About 60).

3 of those fields are primary key fields: ProductCombo, ChannelCombo, and
IndustryCombo.

I'm looking to design the form so that there are three combo boxes for the
three primary keys that I have, and after I choose a value out of the 3rd
combo box, the rest of the fields will populate in the remaining 57
textboxes. Anyone have any suggestions on how to do this? I've seen examples
on having a form find the record of one combo box, but not 3...

Thanks a bunch,

Nick

 

[KARL DEWEY]

Use a query that is refreshed after update of third combo.

 

[Ron2006]

or after update of any of the three if they are all independent of
each other. If I have selected all three but then change my mind on
the second one I have to have a requery when that one changes also
(and the first one also).

If you do not do this then the only way you will get a new record is
if the third one is changed so you would have to reselect it if you
change your mind on the second one.

Ron