how can i make button1 grayed out when the form is at record=0

Thanks

Faz,
if using a bound form, you can find out if there are any records by counting
the records using the recordsetclone.

The following has not been tested for your exact situation

If Len(Me.RecordSource) >0 Then
If Me.RecordsetClone.RecordCount > 0 Then
Me.Button1.Enabled = True
Else
Me.Button1.Enabled = False
End If
End If

Another possibility applies if your form allows new records.
You can test the New Record property. If the form is at a new record, then
disable the button.

If Me.NewRecord = True Then
Me.Button.Enabled = False
Else
Me.Button.Enabled = True
End If

You would need the code on the On Current event of the form
and on any other event that could change the record source of the form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Faz" <(E-Mail Removed)> wrote in message
news:35744C2D-EBEF-456F-8ED9-(E-Mail Removed)...
> how can i make button1 grayed out when the form is at record=0
>
> Thanks

Thank you very much

"Jeanette Cunningham" wrote:

> Faz,
> if using a bound form, you can find out if there are any records by counting
> the records using the recordsetclone.
>
> The following has not been tested for your exact situation
>
> If Len(Me.RecordSource) >0 Then
> If Me.RecordsetClone.RecordCount > 0 Then
> Me.Button1.Enabled = True
> Else
> Me.Button1.Enabled = False
> End If
> End If
>
> Another possibility applies if your form allows new records.
> You can test the New Record property. If the form is at a new record, then
> disable the button.
>
> If Me.NewRecord = True Then
> Me.Button.Enabled = False
> Else
> Me.Button.Enabled = True
> End If
>
> You would need the code on the On Current event of the form
> and on any other event that could change the record source of the form.
>
>
> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>
>
> "Faz" <(E-Mail Removed)> wrote in message
> news:35744C2D-EBEF-456F-8ED9-(E-Mail Removed)...
> > how can i make button1 grayed out when the form is at record=0
> >
> > Thanks
>
>
>