How to find record on form based on multiple queries

[denileigh]

I currently have a form to manage inventory. On the left side of the form, I have a list box that shows all of the items in the database and finds the record on the form based on the selection.

I would like to have toggle boxes or something underneath the list box that when clicked will sort the box by vendor and item and another that when clicked will sort the list by part number and then select the record on the form based on the selection at that time.

I have no idea how to accomplish this...can anyone help?

 

[ions]

I think you can do this in Code.

Just change the properities of the listbox such as rowsource (to another query) Make sure your bound column is always in the same spot though. (Usually bound column is column 1 and is invisible anyways) You will also have to change the column widths to match the new query.