Look up list

  • Thread starter Thread starter Tom Antrim
  • Start date Start date
T

Tom Antrim

Hello
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 or descending 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.
 
With Macros/VBA, almost anything can be accomplished.

To open a form, use the OpenForm action/method. To resort the list, change
the ORDER BY clause of the rowsource query.
 
Back
Top