How to error check fields arent null when switching to subform

[Guest]

Hello,
I have a form with a few subforms on it, where I need the user to fill
out the field txtFristName on the main form before switching to a subfrom
(either by tabbing or clicking). Is it possible to display a message to the
user that they must fill out this field before continuing to the subform?
Access isnt reporting an error so i can't trap it with the onError command.

thanks for any and all help!
ben

 

[Guest]

On the OnGotFocus event of the subform control in the main form you can write
the code

If isnull(Me.FieldName) then
msgbox "Must enter value in field name"
Me.FieldName.SetFocus
End If

 

[Guest]

Thanks for that responce. It was exactly what i was looking for and you did
it very quickly. (i know it was a simple problem, but im still very
greatfull)

 

[Guest]

Glad I could help
Good luck

Thanks for that responce. It was exactly what i was looking for and you did
it very quickly. (i know it was a simple problem, but im still very
greatfull)