If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Get Subform Data
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. |
#2
|
|||
|
|||
Get Subform Data
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 -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jonas" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|