MS Access 2007 Problem

[chimesh]

I Have a MS Access 2007 Database form with Two Command Button. When i click on first command button, it must be disable and second one must be enable. when i click enabled second button then it must be disable and first one must be enable. My problem is How to keep remember which one is enable and which one is disable for future use. that means when i reopened the database in another time enable and disable status of command buttons must be as when i close the database

[June7]

As long as you don't save the form with the changed settings, it should open next time with the original settings.

[A S MANN]

Why not Enable Both in OnLoad Event, & than Enable\ Disable one as per click
That will be easy to remember

[chimesh]

Why not Enable Both in OnLoad Event, & than Enable\ Disable one as per click
That will be easy to remember

Actually I need this for stock reconcile database. When starting reconcile process i need to initialized (delete existing data) and after initialize i need to disable initialize command button until finalize button click. But problem is this reconcile process can take some times more than one day and therefor need to close and reopen database several time.

[orange]

What is the logical condition that would determine if ButtonA is enabled or disabled? The whole process shouldn't be dependent on clicking a button--there must be some logic/criteria test to determine the setting.

eg. Is there data that should be deleted before continuing ?? If yes then Initialized button should be enabled...

[chimesh]

What is the logical condition that would determine if ButtonA is enabled or disabled? The whole process shouldn't be dependent on clicking a button--there must be some logic/criteria test to determine the setting.

eg. Is there data that should be deleted before continuing ?? If yes then Initialized button should be enabled...

Actually I need this for stock reconcile database. When starting reconcile process i need to initialized (delete existing data) and after initialize i need to disable initialize command button until finalize button click. (That mean after finishing reconcile process) But problem is this reconcile process can take some times more than one day and therefor need to close and reopen database several time.

[orange]

So what does this mean in business (not just reconcile process) terms.
This process takes more than 24 hrs to run?

In plain English what is a stock reconcile? An example would be helpful.

Have you see/read this by Allen Brown?

[A S MANN]

Why not Try this
When the form is loaded you want initializedCommand is enabled and finalize desabled

OnLoad Event Of Form
Me.[initializedCommand].Enabled = True
Me.[finalizeCommand].Enabled = False