Databinding with Combo?

[jmoudy77]

Hi, I've got a flight record table that is created every time I enter a new individual in my database. I created an autoform from the "flight record" table, with the hopes that I could add a combobox, select individual, input flight data into the text fields, and have it update that individuals "flight record" table. I'm stuck as to figuring out how to make the text fields bind to the individual's table that I've selected in the combobox. Any help?

[cyberdwarf]

I would design the form with a top-half containig your record-selection fields (combos, etc) and a lower section containing a sub-form with the record resulting from the top-half lookup.

Come back to us, if you need further explanations.

HTH

Steve