Prev: Exporting curretn recordset to Excel - only working first time!
Next: Spell Check specific fields on a subform
From: SamMexico via AccessMonster.com on 7 Jun 2010 11:15
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201006/1

From: Marshall Barton on 7 Jun 2010 11:22
SamMexico via AccessMonster.com wrote:
>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.

--
Marsh
MVP [MS Access]
From: nrgins via AccessMonster.com on 7 Jun 2010 13:49
Just use the dropdown's AfterUpdate event to enable/disable the buttons based
on the user's selection.


SamMexico wrote:
>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

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: Exporting curretn recordset to Excel - only working first time!
Next: Spell Check specific fields on a subform