referencing the nth row in a sub form

  • Thread starter Thread starter kremzow
  • Start date Start date
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
 
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.
 
Back
Top