Runtime Error 1004

[spnz]

Good morning

I had yesterday off work and have come back to a nightmare.

The database we use doesnt work the way it should anymore.

There is a switchboard which gives us the option to show a booking form...Worked fine until someone did something to it yesterday.

When I click on the command button to load the form I get an error saying that there was a runtime error 2001 " You canceled the previous operation"

How do I fix this??? I so confused.

I have tried opening the form other ways but it appears to be locked and wont open.


Please if someone could share some light!!!!


TIA

 

[MStef]

Hello Spnz!
???? error 1004 or 2001 ?????
Do you have any VBA under this button????

 

[spnz]

Sorry......2001

small code only to open the form
Private Sub BtnManBkgs_Click()
DoCmd.OpenForm "Bookings"
End Sub


This is driving me nuts!!!

 

[MStef]

Check is there any VBA under this form, (ON OPEN or ON LOAD sub). If yes, check this VBA.

 

[spnz]

Its a tough one as I can't even get into the design view of the form.

I have managed to remove the form and inserted a new form.

Very confusing why this would happen tho