Continuos form

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

Guest

How do you reference the current record in a continous form? When i say
current record, it is the record where the cursor is positioned...or the
record you are currently editing...
 
To refer to the current record, you could just simple refer to the control
on the form. The current record's value for that control is what will be
returned. For more information, we'll need more information. For example, if
you're trying to refer to it from the main form and the continuous form is a
subform, the syntax would be:

Me.ctlNameOfSubformControl.Form.ctlNameOfControl

"Me" will work in VBA, drop it if you are using the above in a calculated
control. The ctlNameOfSubformControl is the name of the control on the main
form called a subform control. This is a container that holds the subform.
Depending on how you added the subform to the main form, the name of this
control may or may not be the same as the name of the subform.
 
Back
Top