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.
 

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

Similar Threads

Record insert/delete anomaly 0
Check whether form is is 'edit' mode 1
Set current record in a form on open 3
Refresh Pop up 2
navigating from a subform to the main form 1
How to write to a textbox in Detail section 1
Access 2010 Report Button 0
Embedded Macros 1

Back
Top