Error message for something ive done 100x - help!

[bpdavis]

I created a simple form, and it has a command button that makes a certain text box visible. In the onclick event, the code says

me!startyear.visible = true

startyear being the name of the textbox. Yet I get the error message :

The expession On Click you entered as the event property setting produced the following error: A problem occured while MS Access was communicating with the OLE server or ActiveX Control.
*The expression may not result in the name of a macro, the name of a user defined function, or [event procedure].
*There may have been an error evaluating the function, event, or macro.


I have used this command many times(diff computer) without a problem. What is going on here? This is access 2000 Thanks.

 

[Rich]

Look for missing references, there have been many posts here on the subject, so you can search for more detailed help.

 

[bpdavis]

None are missing...... I'm also not using any modules

 

[Rich]

Then where does this statement come from me!startyear.visible = true ?

 

[bpdavis]

I did what some suggested - making a new database and copying the objects over. Worked like a charm. Not only that, but it cut the size from about 2.5megs to about 400k. Very weird. Thanks for the help.

 

[David R]

The size difference is likely due to not compacting

Access is a memory hog, and gets worse with use. Regularly compact your database and you'll see the size stay fairly low.