Before Update event on a continuous form doesn't work

[chuckcoleman]

Hi, I have a continuous form that is a subform. I am trying to get the forms BeforeUpdate event to work and so far, nothing that I've tried works. I have some code that will check if a condition exists and it if does, I want the BeforeUpdate event to work so I can cancel adding the record, along with the appropriate message of what's wrong.

What's the trick to getting forms BeforeUpdate event to work?

 

[June7]

It should.
"Doesn't work" means what - error message, wrong result, nothing happens?
Maybe should be using BeforeUpdate of some control to validate data.
Provide your code for analysis (or the database).
How are you committing record - move to another?

 

[chuckcoleman]

It should.
Provide your code for analysis.

I've tried a few different things including MsgBox("BeforeUpdate"). They all work in the AfterUpdate but I would like to prevent the record from being added.

 

[chuckcoleman]

I've tried a few different things including MsgBox("BeforeUpdate"). They all work in the AfterUpdate but I would like to prevent the record from being added.

TIME OUT! I have been working exclusively in the VBA editor and I just notice in the forms design Before Update event I had a macro. I apologize. Let me convert that to VBA . SORRY!

 

[The_Doc_Man]

Glad you noticed that. And the apology is noted, but actually not necessary. You aren't the first person to suddenly realize on your own what your error was, and you surely won't be the last. So join the club - the non-exclusive club of folks who trip over their own code. Wish I had a nickel for every time I've done that.