[airspirit]

You tell me how foolproof this is: There are two buttons. One is labelled "search", and one is labelled "records". If you push the "search" button, it brings up a form in which you can type in data and run queries and filters on your other form, which is brought up by the "records" button. She didn't want to use the search button, so she started entering data into the records form hoping it would do the same thing.

Mind you, the title bar of one form is labelled "INVENTORY SEARCH FORM - PERFORM SEARCHES HERE" and the other is "INVENTORY RECORDS". On the "records" form on the bottom, it refers you to the "search" button if you want to search for something.

I don't know how much more foolproof I can get it without branding the form in big red ARIAL BLACK letters "YOU CAN NOT SEARCH FROM THIS FORM YOU MORON!". Mind you, this is just one part of the entire database (part of the reason I had to do it this way was because she couldn't figure out how to synchronize, and tables started to mysteriously disappear in the *mdb access dbase I had her on ... this isolates her damage potential) ... and I had to build it this way, because she didn't want to have to worry about pop-up prompts for search data (too confusing, she said). She wanted one form to search and one to display data ... now she's saying that even THAT is too confusing.

She is not a real brainiac ... but what is scary is that she does the accounting for that business nearly singlehandedly, with an assistant that is hired solely to fix the mistakes she makes ... and this dbase is a hell of a lot easier to use than the UNIX terminal interface she uses for her accounting.