Forced Data Entry on Subform

  • Thread starter Thread starter faapa via AccessMonster.com
  • Start date Start date
F

faapa via AccessMonster.com

Hi

I knw this question gets asked alot but i've tried looking for a suitable
answer but nothing seems to work on my form!!

I have a Form (frm_pt) with a subform (frm_pt_sb)

When a user enters info in the parent form, i'd like user to be prompted to
enter info in the subform. If they dont, then all the info in the whole form
is not saved....so far, i can get the info in the parent form to be
compulsory entry but i cant seem to carry this requirement on to the subform..
 
If this is a bound form you have to be aware of a few things.

As soon as your user clicks on the subform, the dirty main form is going to
perform its update/add processing before relinquishing control to the sub
form. It is the way Access works and there is no way around it!

So if your user decides not to enter data in the subform you will have to
delete the main form underlying record. You could change the main form to be
unbound but then all the record processing falls into coding.

You have some design decisions to make. Sorry for the news!
 
Back
Top