Axis it worked but........

[gino]

Hey Axis,

Thanks again...this time it did work, but I was wondering if there is another route to this because after I fill in the required field it doesn't tab to the command field. i guess because its not enabled. Refer to my last post if you are confused...... This is what you gave me.

If Not IsNull(Me![Field]) Then Me![CommandButton].Enabled= True Else MsgBox "You must fill in this field to continue.", vbOKOnly

Works well but is there another way where I could have the command button enabled and still require the field to be not null? I know i ask to much but yes you are very smart..........

Thanks...Again.......!!!!!!

 

[Axis]

Try this

If Not IsNull(Me![Field]) Then
Me![CommandButton].Enabled= True
Me![CommandButton].SetFocus
Else
MsgBox "You must fill in this field to continue.", vbOKOnly
End if