Sequencing Data in Sub Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Ruralguy:

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

Thank you:
Joy
 
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
Click to expand...
[quoted text clipped - 15 lines]
Click to expand...
 
Back
Top