Combo Box

  • Thread starter Thread starter DW
  • Start date Start date
D

DW

How do you make a combo box hold its value?
When you close a form and reopen it, it's previous selection that was
selected is gone.
The list in the combobox is not from a table, but a list that I
defined.
It maybe that I am thinking wrong, but what I am trying to do is use
this for a reference in multiple forms, so that you don't have to set the
date in every record. Is there a better way of doing this.
 
How do you make a combo box hold its value?
Click to expand...

A Combo Box is a display tool, not a repository for data.
When you close a form and reopen it, it's previous selection that was
selected is gone.
Click to expand...

That's correct. An unbound combo box has no place to store a memory of
what was selected the previous time that you opened Access!
The list in the combobox is not from a table, but a list that I
defined.
It maybe that I am thinking wrong, but what I am trying to do is use
this for a reference in multiple forms, so that you don't have to set the
date in every record. Is there a better way of doing this.
Click to expand...

Data should be stored in Tables, and only in Tables. What exactly are
you trying to do with the combo box's value? Can you just leave the
form open, if you want a criterion to be selected for a session? You
can make it invisible, and still have the value available.
 
Back
Top