Enable/Disable Button

[P.Malius]

Hello, I have a form containing a button to approve documents, the button adds a time and date stamp as well as an 'Approved' field in the table once click. I want to make it so that the button can only be clicked once. I have the piece of code to do that, but it won't work, says it cannot find the object. I can't, for the life, of me figure out what is wrong. Someone please help???

Private Sub form_Load()
If DLookup([Q1ApprovalStatus], [tblCustomerSpecification], Q1ApprovalStatus = "Approved") Then
    Forms![frmSpecification]![Command189].Enabled = True
    Else
    Forms![frmSpecification]![Command189].Enabled = False
    End If
End Sub

[Missinglinq]

Your DLookup is malformed! Don't you hate when that happens?

Should be

If DLookup("Q1ApprovalStatus", "tblCustomerSpecification", "Q1ApprovalStatus = 'Approved' ") Then

The syntax for Functions with 'Where' clauses varies depending on the Datatype of the Field.

Linq ;0)>

[orange]

see http://www.techonthenet.com/access/f...in/dlookup.php

for use/syntax of DLookup()


OOoops: Linq is a faster typer.

[P.Malius]

Hi, Thanks for the replies. Unfortunate your method did not help me (probably due to my lack of knowledge with Access).

I have however solved my issue by using the code below with a timer of 1 seconds in the for properties.

Private Sub Form_Timer()
If Forms!frmSpecification.Q1ApprovalStatus = "Approved" Then
    Forms![frmSpecification]![Command189].Enabled = False
    Else
    Forms![frmSpecification]![Command189].Enabled = True
    End If
End Sub

Thanks again for your time