Combo Box

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.
 
J

John Vinson

How do you make a combo box hold its value?

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.

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top