subform - gotorecord - object name

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

Guest

hi ng,
trying to read the rows in a subform within in my access
2000 database, but it is not working.
have tried this:



for i = 1 to limit.

docmd.gotorecord, acdataform, "my_form", acnext

next i.

but, always the debugger tells me: object not open.

any helpful hint out there in cyberspace??

thanks in advance

jokobe
 
-----Original Message-----
hi ng,
trying to read the rows in a subform within in my access
2000 database, but it is not working.
have tried this:



for i = 1 to limit.

docmd.gotorecord, acdataform, "my_form", acnext

next i.

but, always the debugger tells me: object not open.

any helpful hint out there in cyberspace??

thanks in advance

jokobe
Click to expand...
Hi jokobe
a subform must be referenced using a hierachy starting
from the main form.

[MainForm].[MainFormSubformControl].form

an alternative is to use the subform recordsetclone

dim rst as dao.recordset
set rst=me.recordsetclone

for i = 1 to limit
rst.bookmark=me.bookmark
rst.movenext
me.bookmark=rst.bookmark
next i

luck
Jonathan
 
hi jonathan,

thanks for your fast answer. the trouble with the
reference is, that it is working for a field, but you
can't reference a subform properly within a gotorecord
command - the web is full with not working solutions.

the good message is:
your solution recordsetclone solution is working -
every now and then.
starting the code for the first time is fine,
starting the code again raises an error:
no object.
the recordset count returns in both cases 14 (that is
correct), but with the second start the i = 1 to limit
only runs twice, raising an error then. this is not
only a pity, but somehow unexpected.

alas, thanks again for fast and helpful hand

joachim
-----Original Message-----
-----Original Message-----
hi ng,
trying to read the rows in a subform within in my access
2000 database, but it is not working.
have tried this:



for i = 1 to limit.

docmd.gotorecord, acdataform, "my_form", acnext

next i.

but, always the debugger tells me: object not open.

any helpful hint out there in cyberspace??

thanks in advance

jokobe
Click to expand...
Hi jokobe
a subform must be referenced using a hierachy starting
from the main form.

[MainForm].[MainFormSubformControl].form

an alternative is to use the subform recordsetclone

dim rst as dao.recordset
set rst=me.recordsetclone

for i = 1 to limit
rst.bookmark=me.bookmark
rst.movenext
me.bookmark=rst.bookmark
next i

luck
Jonathan
.
Click to expand...
 
Back
Top