Making form fields required with an SQL back-end

[vlitim]

I have a form where I want to force the user to enter certain fields

The supporting database is SQL so I cannot update the table properties (linked to sql server) to required

i have tried using validation rules i.e. is not null but these are ignored

is there a way to do this?

 

[Gazer44]

within the 'ON click' properties of the close form button, setup criteria that checks these fields have an entry.

We'll assume you need criteria in text boxes - 'fieldA' & 'fieldB'

Put in Event Procedure code as-

If (IsNull(fieldA) Then
Beep
MsgBox "Please enter required criteria"
DoCmd.GoToControl "fieldA"
Exit Function
End If

If (IsNull(fieldB) Then
Beep
MsgBox "Please enter required criteria"
DoCmd.GoToControl "fieldB"
Exit Function
End If

The above code will check if fields A & B are blank, if so they'll flag up the message and set the curser flashing in that particular field.

Hope this helps.

 

[Gazer44]

sorry, slight typing error, code should be:-

If IsNull(fieldA) Then
Beep
MsgBox "Please enter required criteria"
DoCmd.GoToControl "fieldA"
Exit Function
End If

If IsNull(fieldB) Then
Beep
MsgBox "Please enter required criteria"
DoCmd.GoToControl "fieldB"
Exit Function
End If

p.s. If your field names have spaces in them (i.e. field A) either change name to fieldA or field_A or put it into the code as [field A]

cheers