continuous form records on subform

[Guest]

Greetings. I have a main form that on it has 2 subforms, both are in
continuous style. SubformB fills with info depending on the record in
SubformA and SubformA fills with info depending on what is on the main form.
My question and user concerns center around SubformA. This subform can have
a varying number of records in it. The users have asked if there is a way to
show which record is the "active" record. Records in SubB are added over
time while those in SubA are generally added at one time. The other question
they posed is can each record in SubA have a way of showing the number of
associated records in SubB.

These 2 items are bewildering since the continuous form style record is
actually one line in design view. Can anyone assist in how these can be
accomplished?

Thank you in advance to anyone responding.

 

[Bob Hairgrove]

Greetings. I have a main form that on it has 2 subforms, both are in
continuous style. SubformB fills with info depending on the record in
SubformA and SubformA fills with info depending on what is on the main form.
My question and user concerns center around SubformA. This subform can have
a varying number of records in it. The users have asked if there is a way to
show which record is the "active" record. Records in SubB are added over
time while those in SubA are generally added at one time.

If you open the subforms in design view and show the properties
window, there is a property called "Record Selectors". If you set this
to "Yes", there will be a little black triangle displayed next to the
current row in the subform.

The other question
they posed is can each record in SubA have a way of showing the number of
associated records in SubB.

Yes: look in the help topic for the DCount function.

These 2 items are bewildering since the continuous form style record is
actually one line in design view. Can anyone assist in how these can be
accomplished?

If you have two subforms next to each other on the main form, just
move one of them over a bit and you should have enough separation
between the two so that the user can see which fields belong to which
form.

 

[Guest]

Bob, thanks. That will suffice for the active record. DCount should also
work. Thanks again.
John