Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Wellington, New Zealand
    Thanked 0 Times in 0 Posts

    Subform BeforeUpdate Event

    Hi All

    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.

  2. #2
    Plutonium Lounger
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts