Lookup List

G

Guest

Hello
I didn't really know where to list this question. We use
alot of combo boxes my users want to be able to click on a
item on the combo box list and change ascending or
ascending order among other things. I understand
when you click on a item in the combo box it will fill in
the field with that value. Is there a way to have a form
pop up when you click on a button that will give me more
then just populating the field.
..
 
S

Sprinks

It's not clear to me what you're trying to achieve, but you could potentially
use the DoubleClick event of the combo box to present a form in dialog mode.
Once the users made their selections, you could then take appropriate action:

strDocName = "YourForm"
DoCmd.OpenForm strDocName, acNormal, , , acFormEdit, acDialog
.....take appropriate action here, e.g.,
Me!MyComboBox.RowSource = "SELECT [fieldlist] FROM YourTable ORDER BY
[fieldlist]
' Requery combo box to reflect changes in RowSource
Me!MyComboBox.Requery

Hope that helps.
Sprinks
 
Top