Main page Form flashing button

[benh]

I have a button on my main page that is "Orders Ready To Invoice"



clicking on that button opens up another form called [work completed]
that is filtered by [work completed]![order has been shipped]=False

that part all works fine, But I would like the button to change color if there is an order ready,
or have the button be invisible if no orders are ready. anything really even a records counter
next to button.

I do have the main page running me.refresh on a timer interval,

So what I'am asking for help on is how do I modify that button of main form by the amount
of records available after filtering in another form.

[benh]

Well I added the counter and it seams to work...... If anyone knows how to modify a buttons attributes based on a number in a query that would be nice to know.

thanks

[ssanfu]

Maybe this will help.This worked for me:

'Private Sub Form_Timer()

    Dim RC As Boolean
    Me.Requery
    RC = Me.RecordsetClone.RecordCount <> 0
    Me.Command6.Enabled = RC
    ' or
    '    Me.Command6.Visible = RC
    'or
    'to change BG color
'    If RC Then
'        Me.Command6.BackColor = vbYellow
'        Else
'        Me.Command6.BackColor = RGB(196, 226, 197)  ' shade of green
'    End If