Results 1 to 2 of 2
Thread: Subform BeforeUpdate Event
2001-05-23, 21:33 #1
- Join Date
- Apr 2001
- Wellington, New Zealand
- Thanked 0 Times in 0 Posts
Subform BeforeUpdate Event
MS Access 2000, Win NT 4
I have a database that has a form with one subform (continuous) in it. This subform has a BeforeUpdate event that is used to validate data.
My problem is that the BeforeUpdate event is firing after a user puts a value into the first field (and then the validation check fails, because the user has not yet entered information into the other fields yet). The BeforeUpdate event is also firing at the correct time when the user exits the record.
MSDN appears not to have any information on this. The only thing that I can think of is that somehow the record is being 'saved' after the entry of the first field.
This problem is also 'inconsistent' and does not always occur!
Any suggestions are much appreciated.
2001-05-24, 03:43 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: Subform BeforeUpdate Event
You haven't provided enough information. If it doesn't always happen, what is different about the times it does?
Does the first field have any code behind it that might trigger the validation? Is the user doing something like clicking on a command button on the parent form (or another subform)? That will trigger BeforeUpdate because records are saved when the form loses focus.Charlotte