Want to open form from list, after form closed, refresh list then move

[bistec]

Long discription I know but...

I have a form that returns a list of records
via SQL in VBA. User can dbl-click to open
form with full details update, edit etc.

After details forms is closed, the list does a refresh
to show changes.

What I would like to do is set a bookmark and return
to that bookmark after list is refreshed.

 

[Aivars]

private sub form_UnLoad(cancel as integer)
'This is procedure of your form with full details update
dim frm as form
dim tempVal

set frm=forms("CallFormName&quot 'Form name which called form with full details update
tempVal=frm!lstList 'Current value of list on form which called form with full details update
frm!lstList.requery
frm!lstList=tempVal
end sub

Aivars

 

[bistec]

thanks for that.

I ended up fixing the problem by
setting a bookmark by before I
requery the form, then calling that
bokkmark back again.