I asked this question on another forum that I didnt like.
I asked how I can disable a button till a certain field is filled in.
I got this response
Select the button u want disbled, right mouse click and find enabled on the properties . Set this to no
Now select the fieled u to be filled to make it active , right mouse click and go to properties. Select afterupdate and click on the three dots next to it. Now click code builder, u will open the vb window. now write the code
If Me![your trigger field ] = "" Then
Me![name of button disabled].Enabled = False
Else
Me![name of button disabled].Enabled = True
End If
problem solved
It works however when I go to a new record the button is still enabled.
What can I do to resolve this
I asked how I can disable a button till a certain field is filled in.
I got this response
Select the button u want disbled, right mouse click and find enabled on the properties . Set this to no
Now select the fieled u to be filled to make it active , right mouse click and go to properties. Select afterupdate and click on the three dots next to it. Now click code builder, u will open the vb window. now write the code
If Me![your trigger field ] = "" Then
Me![name of button disabled].Enabled = False
Else
Me![name of button disabled].Enabled = True
End If
problem solved
It works however when I go to a new record the button is still enabled.
What can I do to resolve this