checking for empty fields

[Guest]

Using a form, how can I make the OK available only after some fields have data?

 

[Guest]

Create a function within the form that check if the fields has data

Function CheckField() As Boolean
If IsNull(Me.[Field1]) Or IsNull(Me.[Field2]) Or IsNull(Me.[Field3]) Then
CheckField = False
Else
CheckField = True
End if
End Function

================
On the After Update event of each relavant field, run the code

Me.[ButtonName].Enabled = CheckField

 

[Guest]

Where should I put the function?

Thank you very much!

Create a function within the form that check if the fields has data

Function CheckField() As Boolean
If IsNull(Me.[Field1]) Or IsNull(Me.[Field2]) Or IsNull(Me.[Field3]) Then
CheckField = False
Else
CheckField = True
End if
End Function

================
On the After Update event of each relavant field, run the code

Me.[ButtonName].Enabled = CheckField

--
Good Luck
BS"D

Using a form, how can I make the OK available only after some fields have data?

 

[Guest]

Sorry it took me a while to come back to you
Put the function within the form (open the form in design view, in the menu
bar select View > Code), not in a module.

--
Good Luck
BS"D

Where should I put the function?

Thank you very much!

Create a function within the form that check if the fields has data

Function CheckField() As Boolean
If IsNull(Me.[Field1]) Or IsNull(Me.[Field2]) Or IsNull(Me.[Field3]) Then
CheckField = False
Else
CheckField = True
End if
End Function

================
On the After Update event of each relavant field, run the code

Me.[ButtonName].Enabled = CheckField

--
Good Luck
BS"D

Using a form, how can I make the OK available only after some fields have data?