ComboBox Initialization

[Ilya]

Hi everybody:
The client requested Combo Box initialization in such
away that last sesssion selection will be always the
starting point for new session.
It is not the problem for me to catch last query at the
event of form closing, put them into aux table and
retrieve on the event of opening the form.

 

[Michel Walsh]

Hi,


Have you tried using a Database property. For a database property,
first, create it (just once in the database life):


CurrentDb.Properties.Append CurrentDb.CreateProperty("continueWith", dbText,
"Hello World" )


Then, just use the property:


... = CurrentDb.Properties("continueWith")

to read it, or, to write in it:

CurrentDb.Properties("continueWith") = ....



The property survives the session, ie, it is fully initialize when you
re-open the database.



Hoping it may help,
Vanderghast Access MVP