BeforeInsert form event not firing

[TOM]

For reasons best known to Access the BeforeInsert form
event stopped firing. I had code in there and it has
stopped executing. I have repaired the database but to no
avail. I have removed and re-instated the event but no
good. I have put a breakpoint in but it never gets there.

I have WinXP Pro and Access 2003.

 

[TOM]

PS the BeforeInsert event does work on other forms.

 

[Allen Browne]

Is the form being dirtied programmatically? For example, if you set a value
in the form's Current event, then it is already dirty when it arrives at the
new record. (This may behave differently in different versions of Access).

If that does not solve the problem, create a new (blank) database, and
import everything. This should cause Access to recreate the form if it is
partially corrupt.

 

[TOM]

Code in OnCurrent does not stop the BeforeInsert event.

I have another form that works perfectly even though I
have code in the OnCurrent that changes text values.

I suspect the form is corrupted!