How do I change the record on a sub form

[tinkiewinkie]

I am trying to change the current record in a sub-form using VBA code in access. I am using the DoCmd.GoToRecord method, but I don't seem to get the object right. Here is the line of code:

DoCmd.GoToRecord acDataForm, Forms("frmFind&quot("subFrmFind&quot.Form, acGoTo, 12

Where subFrmFind is the subform and frmFind is the main form. I want it to go to record twelve in this example.

Whenever I trigger this code it responds with an error:

The expression you entered is the wrong data type for one of the arguments.

Thanks in advance.

 

[mp9]

Forms![frmFind]![subFrmFind].Form

may help?

http://www22.brinkster.com/accessory/

 

[tinkiewinkie]

Yea, I tried that one, but still no luck. I get the error:

Run-time error 2498

An expression you entered is the wrong data type for one of the arguments.

???? It works if it is not a sub form without the form bit at the end - Stuck!

Thanks

 

[Majnun]

Here is a link to microsofts solution to this problem using a macro, i was also having trouble with this function... you'd think there would be a more direct solution, but this macro thing works:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q209765

 

[rickgrimes]

tinkiewinkie,

Try Docmd.GotoRecord, acForm, "subFrmFind", acGoto, 12

According to reference, the name of the form should be a string and must be any 'open form'.

No need for naming conventions as the 'acForm' indicates the proper object.

See what you see.

Rick.