In a child form I have a combobox which runs a SQL query on a linked table (containing contacts) to allow me to choose a record.
If I update the linked table with another contact and then use the combobox its query does not find the new contact. The contact table is updated.
I can manually make this work by doing a shift+F9 refresh when the combobox is active. I want to make this refresh automatic. I have tried inserting Me.Refresh and Me.Requery code behind the click event for the combobox.
What is the code for the manual shift+F9 and where should it go to make it work?