I have a continuous form based on a query. In the detail section of the form, I have action buttons that perform several updates to the table when pushed. The results of these updates are then displayed on the form. This works as planned.
The issue:
The form as it sits is “busy”. I would like one of the action buttons to disappear when pushed. I would like the second button to remain invisible until the first button is pushed, since they do sequential operations.
I have code for the first part to make the button disappear, in the timer section of the form, but it works globally- the button disappears for all the records displayed based on the results of the first record it returns.
Dim btnvis
btnvis = DLookup("LD", "tblPalletReturn", "(tblPalletReturn.ID)=[Forms]![frmPalletReturn].[ID]")
If btnvis = "YES" Then
Me.CmdLD.Visible = False
Else
Me.CmdLD.Visible = True
End If
How do I affect only the button for the single record? I am sure this is dead simple, but I can’t figure it out.
Any help would be greatly appreciated.
The issue:
The form as it sits is “busy”. I would like one of the action buttons to disappear when pushed. I would like the second button to remain invisible until the first button is pushed, since they do sequential operations.
I have code for the first part to make the button disappear, in the timer section of the form, but it works globally- the button disappears for all the records displayed based on the results of the first record it returns.
Dim btnvis
btnvis = DLookup("LD", "tblPalletReturn", "(tblPalletReturn.ID)=[Forms]![frmPalletReturn].[ID]")
If btnvis = "YES" Then
Me.CmdLD.Visible = False
Else
Me.CmdLD.Visible = True
End If
How do I affect only the button for the single record? I am sure this is dead simple, but I can’t figure it out.
Any help would be greatly appreciated.