return to same record after closing a form
Chaim,
Have a look in the online Help for SaveSetting and GetSetting. These allow
you to save and retrieve values to/from the registry. You would need to
check these values in code before applying the forms' RecordSource (also in
code).
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Quote:
> Hello everybody:
> If I close a form, how do I reopen it on the same record I just left? I
> tried remembering the record Number in the clipboard, but then GoToRecord
> doesn't accept my clipboard as an argument, nor another record in a temp
> table...
> It's a persistance problem....
> Any help would be greatly appreciated
> Chaim
