Sequencing Data in Sub Form

[Guest]

I have a sub form with four columns, they are rollup number, rollup
desciption, estimate number and estimate description. I have a table that
has the rollup number with a list of the estimate numbers and estimate
description that correspond to that rollup number.

I want to pick a rollup number and have access automatically populate the
sub form with the associated estimate items and description, which could add
anywhere from five lines to fifteen lines.

Is that possible? I am not very strong with visible basic so if it is
possible could you help with the code to do it?

Thank you in advance for any and all help.

Joy

 

[ruralguy via AccessMonster.com]

If I understand you correctly, there is no code needed. Just set the
LinkChild/MasterFields properties of the SunFormControl to the Rollup Number
controls of the forms.

 

[Guest]

Ruralguy:

I am not finding the LinkChild/Materfields properties of the Sun(sub)
subformcontrol. Could you please provide additional direction.

Thank you:
Joy

 

[ruralguy via AccessMonster.com]

Forms are displayed on other form by means of a SubFormControl. Often this
SubFormControl is named the same as the form it displays (because that is the
default name) but it is not a requirement. You know you have selected the
SubFormControl when the Data tab has the LinkChild/MasterFields properties on
it. It can be a little tricky to select but just keep trying.

Ruralguy:

I am not finding the LinkChild/Materfields properties of the Sun(sub)
subformcontrol. Could you please provide additional direction.

Thank you:
Joy

If I understand you correctly, there is no code needed. Just set the
LinkChild/MasterFields properties of the SunFormControl to the Rollup Number

[quoted text clipped - 15 lines]