getting index for DoCmd.GoToRecord , , acGoTo

[rcoutts]

I want to use the GoToRecord action with acGoTo to make the a specific record active in my table, but am clueless as to how to find the index to that record. I can easily extract data from the record I want using DLookup(...) but what is the prefered way for finding the index to the record in my table?

Thanks!
Rich

 

[Sawatzky]

try

docmd.findrecord

regards astrid