Value Field in ADD mode

[Gerrit.B]

I want to disable some buttons depanding on a value of a field.
If the value >0 then all the buttons enabled.
But now my problem, when adding a record the value off the field is empty.
I tried is null but that didn't work!

Current Code.

If Me.SelectedAWB > 0 Or Null Then
me.cmd1.Enabled=true
Else
me.cmd1.Enabled=False
End If
End Sub

How can i fix this problem.

G.

 

[alansidman]

Set the field properties to Enabled by setting the On Load property in the form properties
Alan

 

[revans]

try

If Me.SelectedAWB > 0 Or IsNull(Me.SelectedAWB) Then
...

hth,

Rich

 

[Gerrit.B]

Both solutions didn't work for me.
Now if you code below the appropriate burrons.

Private Sub Command103_Click()
fnPause (2)
On Error GoTo Err1:
DoCmd.GoToControl "SelectedAWB"
DoCmd.RunCommand acCmdCopy
Err1: DoCmd.CancelEvent
MsgBox "Not possible if no record is selected", vbOKOnly
End Sub

This works only when a record is sewlected it shows this message, it may only be seen as the error accours.
What should is change in the code.

G.

 

[Gerrit.B]

Private Sub Command103_Click()
fnPause (2)
On Error GoTo Err1:
DoCmd.GoToControl "SelectedAWB"
DoCmd.RunCommand acCmdCopy
Exit Sub
Err1: MsgBox "Not possible if no record is selected", vbOKOnly
End Sub

Solved problems with code above.

G.