Hi.

I have a DB that needs to update a table each day.

The problem is that I have it set up so that when the users open the DB it jumps straight into the form and does not display the data base window so they can't mess around with anything.

When I run my batch file to execute the macro and update the table it does not run because the form opens as soon as the data base opens and the form relies on the table being updated.

Does anyone know a way around this? Can I somehow bypass opening the form automatically for the batch file? Or put something in the macro that closes the form before continuing?

Thanks a million

maybe use two forms. A "splash screen" or loader form the updates the table and then opens the "main" form and closes itself.