G
Guest
I've created a before update event for a particular form ... the only problem
is, before it even runs I get a strange error message (no error code) that
says the "Expression Before Update as the event property setting has produced
an invalid outside procedure." It doesn't fire the event procedure ...
doesn't open VBA and start evaluating the procedure at my stop line. This
message occurs on the access form itself.
Does anyone know what's causing this? Strange things in general seem to be
happening to my database itself (yesterday the AutoNumber function for one of
my tables which had been at 2500-something, started over at 1 and started
giving new records existing autonumbers). Is there a way to troubeshoot this?
Just in case, here's the first few lines of the Before Update event procedure.
Private Sub Form_BeforeUpdate(Cancel As Integer)
'Before saving, validate whether or not name is already in database
Dim varGetEntity As Variant
Dim varGetEntityType As Variant
Dim intMyReply As Integer
is, before it even runs I get a strange error message (no error code) that
says the "Expression Before Update as the event property setting has produced
an invalid outside procedure." It doesn't fire the event procedure ...
doesn't open VBA and start evaluating the procedure at my stop line. This
message occurs on the access form itself.
Does anyone know what's causing this? Strange things in general seem to be
happening to my database itself (yesterday the AutoNumber function for one of
my tables which had been at 2500-something, started over at 1 and started
giving new records existing autonumbers). Is there a way to troubeshoot this?
Just in case, here's the first few lines of the Before Update event procedure.
Private Sub Form_BeforeUpdate(Cancel As Integer)
'Before saving, validate whether or not name is already in database
Dim varGetEntity As Variant
Dim varGetEntityType As Variant
Dim intMyReply As Integer