Ho to goto to a specific record using the Docomd.GoToRecord

Originally Posted by vostrixos

Hi all I need some help.

I'm working on a project where i need to move on some records depending the value that the user chooses from a list box.I use the DoCmd.GoToRecord Like this:

"DoCmd.GoToRecord acDataForm, "ADV_FORM", acGoTo, LIST.Value"

Where LIST.Value is the primery key of a table and that's Auto Number.
The problem is that if the key has the value 8,the current record will be the 8th and not the record that has 8 as key (The numbering has gaps 1-2-4-7-8...etc)

What i want is to move to the current record to the one that has the specified key.The help file talks about expression as a fourth argument of the DoCmd so I tried:

"DoCmd.GoToRecord acDataForm, "ADV_FORM", acGoTo, [ADV]![code]=8"

But didn't worked.Is there a way to do that whith DoCmd.GoToRecord,or should I try SQL?(I will be needing help with this too..)

Thanks for any help

Originally Posted by vostrixos

I've tried the DoCmd.FindRecord but nothing huppents.Actually what i get from the debuging is that DoCmd.FindRecord don't make the record which i want as the current record.Am i doing something rong?

DoCmd.FindRecord makes the record that looks for current or not?The help file isn't helpfull at all...