Look up list

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

 

[[MVP] S.Clark]

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.

 

[Guest]

Thank you

-----Original Message-----
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.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting





.