Go to specific record after requery (1 Viewer)

[vagelisr]

Hi to all.

I have 2 forms.
Form-Header that takes the data from a query
Form-Detail that takes the data from table.

I want to know if it is possible when i close the form-detail (the form-detail open from a button in the form-header) make requery in the form-header and show in the first line a specific record and not the first one.

Thanks and regards.

 

[Ranman256]

You contradicted yourself.
You said got to the first record but not the first one. !!???

When you close fDetail,the fHeader should stay on the same record that you left it.
If you started on record 100, it will remain on 100.
Is this what you want?

 

[Minty]

I think you might be better to post up a picture of your two forms and draw some lines with descriptions showing what you are trying to achieve.

 

[vagelisr]

First of all thanks for your time.

Ranman after the requery the first form goto the first record.

What i want to do is.

Let say i see 20 records
From record 21 to record 40
If i select a record from 21 to 40 and open the detail form do anything i want and when i close the detail form
i want in the form-header to see again after the requery the records from 21 to 40

 

[vagelisr]

Finally i found the solution but wright now i have to go.

I return later with the solution i found.