Tools/Options - Click on the General Tab - Put a check mark in the box
labelled "Compact on Close".
As I understand your issue, here is what I would do to resolve the problem.
The FIRST thing - Change Save to NO. You're saving the form, not the data,
when you set this option to yes. When you click on Done, that button has the
focus and YOU are telling it to save the Form in that state.
Each time you fill the form, then tab to the first field, you should see all
fields clear, allowing you to enter new data. Once you move off of that
record (data you just entered), you are posting the record to the database.
There should be no need to click on Done every 10 records or so.
Without stepping through your code, I cannot begin to guess why this happens
>runs a macro to move to the next record, cmdDone, closes the form and Save is>
>set to YES. ItemNo, Description, RetailPrice & cmsSave have the tab stop>
>property set to YES. cmdDone has the tabstop property set to NO. The form>
>cycle property is set to Current Record. The form is used to enter multiple>
>new items in the products table. Everything works, MOST OF THE TIME - &>
>that what is troublesome. Normally when I run the macro, the form opens>
>with the cursor linkingin the ItemNo field as it should. If I have>a
>lot of items to enter, I usually enter them 10 or so at a time, then cli>k
>ONE& reopen the form to add more like saving a word documen> on
>occasion so you don loose everything if the computer decides to elly>up
> Normally all works fine, but once in awhile when I reopen the form, foc>s is
>on the cmdDone button??? Even though the tab stop property is set to NO> It
>will do this repeatedly, until I ompact & Repair the Databaset>en all
>works fine again for awhile. Inconsistencies in software bother me &>I want
>to release this application for use by my wife who is very intimid>ted by
>computers. Is there something I should be doing to correct this, or i> there
>a way in VBA to execute the ompact & Repair Databasefunction??
Message posted via AccessMonster.com