disabling an enabled button that has been clicked.

[aaron47]

I am working with a form in Access to submit a report that reads data from a linked table. On the form, I have a start date, an end date, a 'preview report' button, a 'reset screen' button and a 'publish report to Microsoft Word' button. I have it set up so that the first button is enabled and the other two buttons are disabled. After a user enters the start and end dates and the user presses the 'preview report' button to create the report, I want the code to disable the 'preview report and enable the other two buttons but this doesn't work inside the code for the 'preview report' button because of control focus. How can I change the control focus inside the code?

[rpeare]

before you do anything with opening the report in the ON CLICK event of the 'preview report button' have something like

me.SecondButton.enabled = true (reset screen button)
me.ThirdButton.enabled = true (publish report button)
you *may* need this line
docmd.gotocontrol me.secondbutton
then follow it up with
me.FirstButton.enabled = false (print preview button)

then go on about opening your report as normal

[ketbdnetbp]

Along the same lines as rpeare indicated, personally, I would begin with...

In the form OnOpen event:
Me![Button1].enabled = False
Me![Button2].enabled = False
Me![Button3].enabled = False

Then, in the BeforeUpdate event of the end date control, after any other validation code, something like:

If IsDate(Me![EndDate])=True And IsDate(Me![StartDate])=True then
Me![Button1].enabled = True
Me![Button2].enabled = False
Me![Button3].enabled = False
end if

Thereafter, set the report's modal property to Yes and eliminate the reports min/max buttons.

Then in the OnGotFocus or OnLoad or OnOpen event of the report (provided the form is still open):
[Forms]![FormName]![Button1].enabled = False

Then in the OnDeactivate event of the report (provided the form is still open):

[Forms]![FormName]![Button2].enabled = True
[Forms]![FormName]![Button3].enabled = True

and see if that produces the desired results.

All the best,

Jim

[aaron47]

Thank you for your suggestions. I tried using the gotocontrol method suggested by rpeare but that gave me an error message. However, the description of gotocontrol pointed me to a setfocus method which gave me the desired results.