I have a couple of DLookUps on a form and they only seem to update when i close the form! i suppose i could just enter the data and close the form for every entry, but i was hoping there was some fix i could put on the thing.
Thanks very much. I've also now noticed that the data, whilst updating on the form is not actually making it into the table. I'm giving up. The gods must have been crazy to come up with this access thing. i'm going back to excel where humans are a natural part of the landscape. Thanks again for responding!