referencing the nth row in a sub form

K

kremzow

Hi,

I need to reference the nth row in a sub form, let's say to fill out a
text box only in the sub form's third row.
When I tried to do this, I referenced all instances of that text box or
only the first one.

What I search for is something like

MyMainform1.MyEmbedded1.Report.Row(3).MyTextbox1.value = "The
solution".

By the way - Both main and sub form are bound to recordsets. Is there a
way to use sub forms without binding them to recordsets? (cause I would
prefer to program a correct model-view-controller with correct
transaction- and exception handling.

Thx for ur replies,

Kai
 
W

William Taylor

set the focus to the subform then
DoCmd.GoToRecord acDataForm, "Employees", acGoTo, 7
then set the value of the control
see help for more info.
 

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

Sort rows in a sub-form 5
Errors with Sub Form Totals 4
Sub Form Text Color 4
Sub Form to Unbound main form control 2
Sub form calculations not correct on main form 2
Testing for required data entry in form fields. 6
PopUp Form Help 6
Checking if form is a sub-form 3

Top