Form corruption

[scalextric59]

Hi,
I am having issues with one of my forms. Occasionally, it gets corrupted after changing something. For example, I just changed the background color of one label and I could not save the changes. From there, I sometimes need to restore a copy of the DB I am working in. Other times, I just need to copy the form. I have Access 2003 running on Windows 7.

The form has 8 tabs, around 230 controls, and roughly 2500 lines of codes. I have forms that have more code and about the same number of controls and I have never had an issue with them.

I just want to mention that I rebuilt this form from scratch a week ago,
and did not have any issues until yesterday.
Any idea what is going on?

Thanks.

 

[vbaInet]

I remember that happening to me in a networked environment, but a local Office application. To get round it the moment you drop a control SAVE immediately and CLOSE the form. Open it and it will be fine. A possible bug but I didn't bother figuring it out since I had my laptop and was upgrading to 2007 (at the time)

 

[scalextric59]

Thanks! I will try that the next time I have this issue.

 

[vbaInet]

Goodie! Let us know if that works for you.

 

[scalextric59]

It did not work. Made a change, clicked Save, and immediately got the message "Microsoft Access has stopped working. Windows is checking for a solution to the problem...". So, I deleted a control and tried to save, but got the same message. This is frustrating.

 

[vbaInet]

Try this instead. Make a change, Click the Close 'X' button. Click Yes to save.

 

[scalextric59]

That did not work either. However, I have noticed that the corruption appears after I run the form; as long as I do not run the form, I can keep doing changes. Moreover, it appears that it is the database the one getting corrupted. I imported the form from my backup and some comboboxes were not working. When I restored the DB, it worked fine.

 

[scalextric59]

I figure it out. There was a combobox whose rowsource was being set to SELECT <table>.* FROM..... The table has 12 fields and the combobox only 3 columns. It was showing the data, but once the form run the corruption appeared. The rowsource for this combobox is set in code, depending of options chosen, and the query for one of the options was wrong. I fixed the query and the problem is gone.

 

[vbaInet]

So yours wasn't anything to do with the application but it was more of a complex query! Glad you got that sorted.