Button1=previous record. Push Button on record zero=CRASH

  • Thread starter Thread starter Faz
  • Start date Start date
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
 
Thank you very much

Jeanette Cunningham said:
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
Click to expand...
 
Back
Top