T
Ted
i have two forms which for simplicity we'll call mainform and subform, the
latter being the nested/linked.
the linking parent/child fields are last name, first name, mi.
there are three other fields which are used along with the above in the
composite PK, and they were MRNumber (medical record number of patient),
IRBNumber (experiment number, though actually a text field) and visit (a
number field used for distinguisihing one record in the subform for another).
it's a little disconcerting, though not a show stopper, but when i add a new
record through subform it visit number value which calculated in a click
event to be one more than the preceding highest one for that combination of
PK elements does not appear in the sorted order. i 'turned on' OrderBy visit
in the subform's property window thinking it would have the desired effect of
placing, e.g. visit 5, at the bottom of the datasheet/subform's collection of
visit numbers 1,2,3,4 but despite this it places the new visit 5 atop the
other four visits worth of records.
there is probably something that needs doing, but after much experimenting i
thought i would relay this cunudrum to the readers of the forum.
any ideas/suggestions would be really appreciated.
-ted
latter being the nested/linked.
the linking parent/child fields are last name, first name, mi.
there are three other fields which are used along with the above in the
composite PK, and they were MRNumber (medical record number of patient),
IRBNumber (experiment number, though actually a text field) and visit (a
number field used for distinguisihing one record in the subform for another).
it's a little disconcerting, though not a show stopper, but when i add a new
record through subform it visit number value which calculated in a click
event to be one more than the preceding highest one for that combination of
PK elements does not appear in the sorted order. i 'turned on' OrderBy visit
in the subform's property window thinking it would have the desired effect of
placing, e.g. visit 5, at the bottom of the datasheet/subform's collection of
visit numbers 1,2,3,4 but despite this it places the new visit 5 atop the
other four visits worth of records.
there is probably something that needs doing, but after much experimenting i
thought i would relay this cunudrum to the readers of the forum.
any ideas/suggestions would be really appreciated.
-ted