bookmark problem

[Andreas Wöckl]

Hi!

I have the following problem in my access form:

for example I use a form to display overview data (all employes of a
company) - with a button I go to a detail mode to edit the data - when i
close this form i want to

1.) refresh the overview
2.) set a bookmark to go to the data sentence I have edited

my code on closing the form:

Public Sub reloadForm(ByVal formName)
If IsLoaded(formName) Then
Forms(formName).Bookmark.requery
Forms(formName).Bookmark = globBookmark
End If
End Sub

Without doing the requery I am able to go to de sentence - but the data is
not refreshed..

Can anyone help me?

best regards,

andreas wöckl

 

[Mark Phillipson]

Hi,

I believe it is the form that you need to requery not the bookmark.

i.e. Forma(formName).Requery

If you wish to just refresh one record then try:

Forma(formName).Refresh

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

 

[Adrian Jansen]

I found out the hard way that the requery wrecks your bookmarks. The best
way appears to be to save the current ID, eg the primary key for the record,
then do a FindFirst on the form recordsetclone to go back to the same ID.
And you still have to handle the case where that record was deleted, in
which case the Find fails.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control