Subform record pointer moves when i do refresh

[DeoM]

Hi,
I have MAINform with CUSTOMERsubform. When I click on any record on the CUSTOMERsubform, it opens CUSTOMERDETAILsubform which should show the correct record based on CUSTID field of the CUSTOMERsubform. At first, it doesnt show the correct record but when i did a Me!Refresh, it did it correctly. However, on the CUSTOMERsubform, the record pointer moves up to the first record. I figured this was caused by the Refresh Method. Is there a way or a code which will make the record pointer stay where it should in the CUSTOMERsubform?

 

[TheAceMan1]

How are ya DeoM . . . . .
[ol][li]Is [blue]CUSTOMERDETAILsubform[/blue] embedded on [blue]CUSTOMERsubform[/blue] or the [blue] MAINform[/blue]?[/li]
[li]Where ever its embedded, is [blue]CUSTOMERDETAILsubform[/blue] linked with [blue]Master/Child properties[/blue] to that form, or not at all?[/li]
[li]If not at all, are you synchronizing thru [blue]query as Recordsource with CUSTID criteria?[/blue][/li][/ol]

See Ya! . . . . . .