F
faapa via AccessMonster.com
Hi
I have a form and a subform. Both have fields with required data entry. So
far - i have been able to link the two pretty ok, ensuring the user must
enter data in both form and subform - however...i have a huge problem when it
comes to navigating through records.
when a user enters data in the form, if they use the tab key or even click on
the subform - they must enter data in the subform in order for the record to
be saved....if however, they click the navigation bar, they are able to go to
a new record without filling in fields in the subform!
i've tried everything within my access mind to try and stop them from exiting.
...setting up a validation rule to say that if the form is not null and the
subform is null then setfocus on subform_field1 and cancel = true HOWEVEr
that doesnt allow the user to exit the form and actually enter the subform
(doh)
does anyone have any suggestions? my mind has gone numb...
I have a form and a subform. Both have fields with required data entry. So
far - i have been able to link the two pretty ok, ensuring the user must
enter data in both form and subform - however...i have a huge problem when it
comes to navigating through records.
when a user enters data in the form, if they use the tab key or even click on
the subform - they must enter data in the subform in order for the record to
be saved....if however, they click the navigation bar, they are able to go to
a new record without filling in fields in the subform!
i've tried everything within my access mind to try and stop them from exiting.
...setting up a validation rule to say that if the form is not null and the
subform is null then setfocus on subform_field1 and cancel = true HOWEVEr
that doesnt allow the user to exit the form and actually enter the subform
(doh)
does anyone have any suggestions? my mind has gone numb...