I have a simple combo box in a subform that looks up values from one table and stores them in another. My problem is that when i select a new record in the main form, although the subform changes accordingly, the combo box list the previous record. I have to go Records, refresh to update it. What's peculiar is that if i go into the properties of the combo box and run the combo's query in the query builder it works fine!
Ive been through all the threads i can find on the subject and tried requerys and repaint and the like but none of works.
Yeah, i tried that. Like i say the query works fine, it just seems to be what the combo box displays in form view. I've even put the query (that runs the combo) in the subform to watch how it behaves - and it calls up the correct data! But the combo still lists the previous records!