How can I grey out a Cmd Button if no records are present? 1

[CliffSP]

Hi all

I have a subform and a Cmd button at the bottom that will Preview a filtered report. Is it possible, and how, to grey (disable) this button out if there are no records in the subform?

Many thanks


Cliff

 

[addy]

Possibly something like:

If Forms![MainFormName]![SubFormName].Form.RecordsetClone.RecordCount > 0 Then

MyButton.Enabled = True

Else

MyButton.Enabled = False

End If

 

[CliffSP]

Thanks for the reply...

Unfortunately it doesn't work for me - the button stays live.

I've substituted MainFormName & SubFormName for the actual names and substituted MyButton for the control name.

Was this the right thing to do?

TIA

 

[addy]

Yes, that was correct.

Where did you put this code - on the OnCurrent Event of the Main Form?

 

[TheAceMan1]

How are ya CliffSP . . .

In the [blue]OnCurrent[/blue] event of the subform:

[blue]Me![purple][b]ButtonName[/b][/purple].Enabled = (Me.RecordsetClone.Recordcount <> 0)[/blue]

See Ya! . . . . . .

 

[CliffSP]

Thankyou AceMan1!

I see you are still performing up to the usual standard - many thanks!

Cliff