Get Subform Data

  • Thread starter Thread starter Jonas
  • Start date Start date
J

Jonas

I'm looking for a way to get the data from a chosen record in a
continuous subform. I have a customer form and a continuous subform
with all of the charges associated with the customer. Is it possible
to have a button on the form, prompt the user to highlight a record
(the charge info.) in the continuous subform and get the information
about the charge?

If there is not a way to do this, I'm pretty sure that I can achieve
what I want to do via a list box.
 
Open the subform in design view, and set its Record Selectors property to
Yes. (This is a property of the Form, not of a text box.)

There's now a little box to the left of each row. The user can click that
box, and a sideways triangle points to the current record. The user can
actually click anywhere in that row, and the pointer in the Record Selector
shows which record is selected.

To refer to Text0 in Sub1 on Form1, use:
Forms!Sub1.Form!Text0

For more detail, see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html
 
Back
Top