Cant's access database "You canceled the previous operation"

[bellevue]

I'm in a bit of a pickle here.



Please forgive if I don't use the correct terminology here; the phrase " a little knowlege is dangerous" springs to mind in this situation.

Whilst trying to create a more complicated conditional format than could be handled by the conditional formatting "wizard" I entered some code into the VBA Editor and now I can't access my form.

When I try and access it via the "Direct to Reservations" button (circled below) I keep getting the "You canceled the previous operation" error message:



When I try to access the form via the database window, nothing happens.

Obviously, I can't get into the form to access the VBA Editor to see what I did but I recall it was an "After Update" command; I've managed to get into the VBA Editor (I think !) via the table and below is what is in there for the offending field:



I've tried to delete the code but every time I try and do that, the database closes down saying there's been an error.

To make matters worse, in trying to use an append query to transfer data from my back up I've created duplicates of everything so now the table has 5200 records where it should be 2600 !

The whole question of duplicate records is another subject; to be honest, I'd just like to get rid of the offending code (or whatever it's called) so that I can get into the form again, I'll worry about the duplicates later.

Please Help !!!!!

[R_Badger]

A question immediately springs to mind:

Right click your form, design view gives you the same error?

[bellevue]

Thanks for the reply

Good idea, I've tried to right click the form in the database window and select "Design View" but nothing happens.

[bellevue]

I forgot to add that I added some "code" as well to the field "Dog_Amt_Paid" as "AdterUpdate" and "Exit", see below:



I wonder, would the fact that there are two "commands" (?) for the same field be causing a conflict ? If so, how do I delete one or both ?

[bellevue]

Thanks to those that tried to help but couldn't wait any longer. I've partially solved it myself and have the database working again (phew !) and will sort the duplicate records on another day.