How to requery data on a form automatically

whoisit

Registered User.
Local time
Today, 03:31
Joined
Oct 27, 2004
Messages
28
I am having trouble with forms
When i change data in a form and run an update query, the query does not recognise these changes and updates the wrong number of fields because of this. How do i resolve this problem so that when i update any data on the form it refreshs itself and so the query can recongnise these changes
THANK YOU
 
In the required event:
Code:
Me.Requery

Take the time to boost your VBA knowledge by pressing F1 over every keyword you are given and don't understand.
 
And on which property would this code go on
I think it is onCurrent property but not sure
THANK YOU
 

Users who are viewing this thread

Back
Top Bottom