Disappearing Form

[tomc]

I have a database to track files. In one application the users only had runtime Access so we did a work around using two forms to search on a table, one to search and one to show the results of the search. This was downloaded from Microsoft. From this site I got great help in putting code behind a command button to clear previous search criteria, a la the clear grid toolbar button. Unfortunately, everytime you click the Clear Form button and ask for search results the results form disappears.

The zip file is too large at 233 kb to attach to this post but I will email it to anyone who might be able to help. The first search form is frmSearchFolders and shows the results of a search done with frmSearchFolders_qbf. The problem arises after you do one search and then use the Clear Form button. There is some sample data in the db. I search on Client 1 Matter 1111.

I'm using Windows XP and A2K.

Any help will be greatly appreciated.

Tom tclingen@mindspring.com

 

[ghudson]

Are the fields in your search form bound to a table? If so then that might explain why the forms appears to be disapearing. The form does not have a record source [no records] when the form is cleared. You might want to create a default value for the fields to prevent if this is your problem.

 

[tomc]

The search form has all unbound controls, the results fields all have control sources.

 

[WayneRyan]

Hi Tom,

Did you do a compact/repair before you ZIPped the file? Did you remove
any graphic images? It really should fit.

Failing that, remove any non-critical parts of the app and/or some data.

Wayne