Code to clear entry in form

[moke123]

Hi moke123,

i cannot see the code you've posted.
Thank you!

I only posted your code with indents and code tags so its readable.

My point was you need to set cancel = true.

Your cancel argument could be as simple as

cancel = DCount("nummer", "bonnen_status", "nummer=" & Me.Nummer & " and soort=" & Me.Soort)

But we dont know enough about your data to be precise.

[moke123]

i would not recommend doing anything in a Validation event.
use the event for it's sole purpose, that is to Validate.

if you need to Insert/Update, validate it first then
invoke the Timer Event and do the Inserting/Updating
on that event.

also, are you trying to Update (using SQL) the same record
that is in the subform? if so that is a no, no (the db engine
will give you warning about conflicting records).

I'd be more inclined to use the afterupdate event than a timer, but yes the beforeupdate isn't the place to be adding records.