>Maybe someone can shed some light on what I seem to be missing. I've got a comboxbox where:
>
>BoundColumn = 3
>ColumnCount = 2
>ControlSource = v_estimates.fk_insurance
>RowSource = v_insurance.company,division,iid
>RowSourceType = 6, Fields
>
>The comboxbox also has code in the Click() method that uses the ComboBox.Value to locate the v_insurance.iid records and then populate other fields on the form with those values.
>
>If I set the ControlSource = "", it allows me to select something, and it populates the fields like it should. If it's set to v_estimates.fk_insurance it will let me select an option, but nothing is displayed (in the combobox field) or changed on the form after the selection.
>
> What I want to happen is that the first time on this form, the combobox displays the correct "option" based on the foreign key (fk_insurance). When a new option is selected, the new foreign key is saved and the other fields updated.
>
>Ideas? Thanks.
Do you have temp relations (SET RELATION) between controlsource and rowsource tables? If yes, remove them.
Edward Pikman
Independent Consultant