Very Strange Error

[chris990]

I received a very strange error this morning.

I was going to create a new query with the simple query wizard, but as soon as selected a data source I got a message saying "The expression on Got Focus you entered as the event property setting produced the following error: The text you entered isn't an item in the list."

After this I can select a datasource, but the cursor remains in hourglass mode. It almost seems like this is a run-time error, when I am merely trying to create a new query. In addition to which, I haven't set any events to run on "got focus". Anyone have any ideas on what is causing this and how it can be fixed?

Thanks,
Chris

 

[ghudson]

Do you have a timer running on your form? If so, disable it when making design changes.

 

[chris990]

I don't have a timer unless Microsoft put one in there.

It appears to be ok now though.....as I was about to show the problem to my boss, it somehow mysteriously, although not unpredictably, fixed itself....I looked like an idiot there, and here, so I think my work is done for now. Thanks.

 

[ghudson]

When Access starts to misbehave in a way that you know is wrong it is best to close the db, make a backup copy, reboot your computer, decompile the db, compile the db, repair the db and then compact the db.

Just closing and then reopening it can help but I highly recomment the above steps.