Locking buttons

[SamMexico via AccessMonster.com]

Hi everyone, this may or may not be possible but I'll ask the question anyway.
..

I have a form with two butttons; each opening a different report. 'Report 1'
button and 'Report 2' button.

I also have another form that displays a drop down list where half of the
list relates to 'Report 1' and the other half to 'Report 2'. Is it possible
to make one button inactive if the criteria in the drop down list have not
been selected in the other form?

Thanks for any input you may be able to give me,

Sam

 

[Marshall Barton]

I have a form with two butttons; each opening a different report. 'Report 1'
button and 'Report 2' button.

I also have another form that displays a drop down list where half of the
list relates to 'Report 1' and the other half to 'Report 2'. Is it possible
to make one button inactive if the criteria in the drop down list have not
been selected in the other form?

It probably is possible.

The details depend on which form is open when the button or
combo box is used and, assuming the combo box selection is
made before a button is used, how the items in the combo box
are identified as related to report1 or report2.

 

[nrgins via AccessMonster.com]

Just use the dropdown's AfterUpdate event to enable/disable the buttons based