Relating Table and Form Recordsets

[heedaf]

Can anyone tell me what the best way to move to specific recordset in a form based on a search of its underlying table. I've tried using aboluteposition but they seem to be independent of each other.
Thanks,
DeWayne

 

[ajetrumpet]

Can anyone tell me what the best way to move to specific recordset in a form based on a search of its underlying table. I've tried using aboluteposition but they seem to be independent of each other.

Maybe some definitions would be in order here DeWayne:

First of all, a recordset is not the same thing as a record. Did you mean "record", instead of "recordset"?

A recordset is an object in a collection in Visual Basic. You can open it and move through it, but that's only done within modules. And you can only use the AbsolutePosition property (I think) with dynasets and snapshots, not with table-type sets.

If you are simply wanting to move to a certain record within a FORM, then check out the Docmd.GoToRecord syntax. Moving through the from, especially if you have specific information (criteria) about the record, should have nothing to do with a recordset. You should not need to open one.