Continuos form

V

V Ramos

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...
 
W

Wayne Morgan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top