Funny problem

[HandSam]

I have a 2007 access database that has been working until not long ago when one of the forms gives the following error:
the expression on click you entered as the event property setting produced the following error: User defined type not defined.

This error comes up on every action of the form ie, on click of any button, on load of the form, on unload of the form, on mouse over, on media change etc.

I tried to copy the form and paste it with the aim of refreshing it but it is not working. A previous database having the same form, same code works perfectly. I need to know how to fix this error permanently. Please assist.:banghead:

 

[JHB]

It seems to be some misspelling somewhere in the form modules.
For example: "Dim DBS As Databas" it has to be "Dim DBS As Database"

 

[HandSam]

It is not a misspelled module. There is no module that should work with the form. The form should play audio and videos, and I have used the activex control: WIndows media player to do this. The system has lots of forms, but this is the only form that is faulty. could it be caused by the activex control? All the references needed are ok.
THe form has been working well, and I havent changed anything, but it just stopped.
I have just tried to import that faulty form into a new database, and it behaves in the same faulty way.

 

[JHB]

Ok from your post thought I it had code:

A previous database having the same form, same code works perfectly

Can't you import the form from the previous database?

 

[RainLover]

Just as a thought.

Check your Record Source. Is that working properly.

Try refeshing your Table Links. Do your tables open correctly. Is there any sign of Data Corruption.