Ok...I've tried everything...
My problem ... I've seen it posted 1000 times but the solutions don't work.
I have a form called Quote List.
There is another form called Contacts.
In Quote List I have a Combo box (Combo75) which relates to the Name field on the contacts form.
Problem is when i update the Contacts, the combo box does not update with the new name unless I close and open everything.
I think I have to use requery, I have tried all these - no luck:
on click:
'Me.Combo75.Requery
on update of Contacts Form.
'[Quote List].Combo75.Requery
.....
I've tried a lot and am tired of guessing, help would be appreciated.