tricky form subform issue

  • Thread starter Patrick Stubbin
  • Start date
P

Patrick Stubbin

I hve a subform contained within a main format that is linked to the main
form via two fields, What i wish to do is if the sub form (which is
displayed in data sheet mode) has all of the lijked records (is always a
fixed number of records in the subform 'filled' for the current record of
the mian form, none are 'null', then i wish to have the sub form move to the
next record

how i have tried to do this is to move to the main form, go to the next
record, then go back to the sub form using code, it works ok, but ALL OF THE
TIME<, i am not sure how to check that all of the entries for each record in
the sub form are not null, and only then move to the next record in the main
form.

HOW???
 
Top