I'm using MS Access 2003.
I have a form in Tabular (Continuous) View, so there are many records displayed at a time. I would like to add a command button to each row, enabled or disabled based on the nullness of a specific field on each record. I cannot seem to make it work.
Here's the code in the form's Open event:
This code seems to fire only once (for the first record, I suppose), then makes all the command buttons enabled or not based on that first record.
What am I doing wrong?
Thanks for any help you can give.
Wayne
I have a form in Tabular (Continuous) View, so there are many records displayed at a time. I would like to add a command button to each row, enabled or disabled based on the nullness of a specific field on each record. I cannot seem to make it work.
Here's the code in the form's Open event:
Code:
Private Sub Form_Load()
If IsNull(txtCsrArchiveDetailId) Then
Me.cmdReStageRecord.Enabled = True
Else
Me.cmdReStageRecord.Enabled = False
End If
End Sub
What am I doing wrong?
Thanks for any help you can give.
Wayne