Can I save a variable value over sessions?

[BubbaDave]

I need to be able to save a numeric value over sessions, i.e., have the last value when I re-open my database. It is used for an auto incrementing field in a table. I can't use an autonumber field type because it has to be editable by the user. I tried the tag property in the form and it reads the value just fine, but I can't get the property to update when I assign a new value to it.

Please, I'm looking very bad with the boss. Can anyone help me?
Thanks in advance.

 

[ghubbell]

Hi BubbaDave,
Make a table be it ever so small and store the number there. Open/close, move to another city, it'll always be there for you. Control it each time with an update query or some code. Bingo! (Tell your boss to relax.) Gord
ghubbell@total.net

 

[scking]

Or store it in the registry. This could get to be quite complex unless you use the built-in SaveSetting to save a value in the registry and GetSetting to read a value in the registry. Of course, you would still have to write the handling routines to implement these.

Steve King Professional growth follows a healthy professional curiosity