H
hughess7
Hi all
I have a continuous subform which shows all claim details, that have Part(s)
against them. The claims are a one to many with the Parts. I wanted to show a
count on the form of parts against each claim. If I add a count to the
recordsource query then I lose the ability to edit the data in the subform. I
need to do this to add a Selector code if the user wants to mark the claim as
a selection.
Instead I have created another continuous subform, this has just the claim
ref and the count of parts. Each form has the same sort order and a vertical
scroll bar - is it possible to synchornise these? ie when the user scrolls
down the continuous subform of claim details, the Part Count subform keeps in
sync so you can always see how many parts it has?
If not, I will just change the 2nd subform to a single form and use the
OnCurrent event to keep the Count of Parts displayed correctly.
Thanks in advance for any help.
Sue
I have a continuous subform which shows all claim details, that have Part(s)
against them. The claims are a one to many with the Parts. I wanted to show a
count on the form of parts against each claim. If I add a count to the
recordsource query then I lose the ability to edit the data in the subform. I
need to do this to add a Selector code if the user wants to mark the claim as
a selection.
Instead I have created another continuous subform, this has just the claim
ref and the count of parts. Each form has the same sort order and a vertical
scroll bar - is it possible to synchornise these? ie when the user scrolls
down the continuous subform of claim details, the Part Count subform keeps in
sync so you can always see how many parts it has?
If not, I will just change the 2nd subform to a single form and use the
OnCurrent event to keep the Count of Parts displayed correctly.
Thanks in advance for any help.
Sue