>All along, I've been using combo boxes to select the value of a field. I seem to be having trouble, tho, using it to select a parent record (the details of which are then displayed on the form).
>
>What properties do I need to set (boundto, controlsource, displayvalue, etc) to allow the user to select the record for display (without editing the contents of the field, of course).
>
>Is this a bad methodology? Should I be usiing a different type of object to select the current record?
>
>TIA
As long as the user has enough information in the selection list, this should work with a little help from some code in InteractiveChange method of the combo. Make sure you have a column in the combo that contains a unique reference to the record selected. In the InteractiveChange, use that value to move the record pointer in the table or view, then refresh the form.
Mark McCasland
Midlothian, TX USA