goto record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Florin - 28 May 2008 13:20 GMT

Hi,

In a form I have a command button for a change one record in a subform:

"Me.subform_name.Requery" -> is ok

After that, I use
"DoCmd.GoToRecord , "subform_name", acFirst"

for go to the first record in that subform, but I get an error
"Run time error 2489
The object 'subform_name' isn't open"

Where is the problem?

Thank
Florin

Reply to this Message

Klatuu - 28 May 2008 15:04 GMT

You have to set the focus to the subform control name.

Me.SubformControlName.Setfocus
DoCmd.GoToRecord , , acFirst

Signature

Dave Hargis, Microsoft Access MVP

> Hi,
>
[quoted text clipped - 13 lines]
> Thank
> Florin

Reply to this Message

Florin - 28 May 2008 15:52 GMT

Thanks, it work!

> You have to set the focus to the subform control name.
>
[quoted text clipped - 18 lines]
>> Thank
>> Florin

Reply to this Message