>>>One form is showing data from a related table; the table is selected through a relation in the DataEnvironment.
>>>
>>>When changing the foreign key through a ComboBox, the data from the related table doesn't get updated until the record is saved. Is there a way to update this BEFORE saving the record?
>>>
>>>TIA,
>>>
>>>Hilmar.
>>
>>Try to do
>>
>>goto recno() && to force the relation
>
>I had already tried that - and the ComboBox (where I select the foreign key for the other table) reverts to its previous value, undoing any change select by the user. I used the ComboBox.InteractiveChange event, by the way. Or should I do this later, perhaps in LostFocus()?
Does the ComboBox also have RowSource in the related table? I think the combobox should have an independent RowSource (e.g. a query of related values for the main entry, for example).
If it's not broken, fix it until it is.
My Blog