>I’d like to put a combo box on my form, have the combo box list populated from a cursor and display the associated value from the parent table. I’m not using views or relations only cursors from a select. The parent table has a key (parent.nCatKey) that relates to a child table (child.nCatKey). When a record is displayed the proper text value (child.cCatName) is display in the combo box and when a change is made the proper key is updated on the parent record.
>
>I’ve been able to do this with success if I hand enter the values into the combo box. I would imagine this is something pretty easy to do?
>
>TIA,
>
>/Chris
Look at the recordsource and recordsourcetype properties of the combo box.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer