Print highlighted rows from subform?

[damageinc86]

So how would you get the query into a listbox? Just do the source, and then set the right number of fields so it doesn't just show the first one? Why would a listbox be able to be called upon by multiple users at the same time? I'm just curious, this is my first time ever really delving into using access at all. It's very interesting.

 

[pbaldy]

Yes, the query would be in the row source property of the listbox. You'd set the column count and column widths properties to show what you want. If you use the wizard to add the listbox, it should walk you through it.

With the subform, you have to use a field in the table to keep track of selections. The listbox keeps track of them without one, so each person making selections is just making them in their copy of the front end.