Lookuplist

[Cindy Grover]

I have a project table. Sometimes more than one person
may be assigned to the project. I have a lookup table
with a list of names and set to appear as a combobox. I
know I should probably us a listbox so that I can make
more that on selecuion,bit I don't want the list box to
remain open after I have made my selections. The form
that I will be using to add data to this Project table
will be a continous form as requested by the user.How do
I hide the listbox after I have made selections?

 

[Michel Walsh]

Hi,


Technically, a possible solution is to place the list box in the form
header or in the form footer (not in the form detail section), and to use
its visible property ( MyListBox.Visible=True ' to make it visible).

Ergonomically? you have to decide when (how) it becomes visible, which
is a harder problem than make it invisible, since there, you know that if it
has just lost the focus, the user is done with it.


Hoping it may help,
Vanderghast, Access MVP