Drag in a List Box

If I have a list box that has a row source to a query is it possible to drag
my records up and down the list box to give them a certain order to print on
a report??

--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3

Stephen Lebans has a number of Listbox examples on his website. Here's just
one of them:

http://www.lebans.com/vb_listbox.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Bob Vance" wrote in message
...
If I have a list box that has a row source to a query is it possible to
drag my records up and down the list box to give them a certain order to
print on a report??

--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3

"Bob Vance" wrote in message
...
If I have a list box that has a row source to a query is it possible to
drag my records up and down the list box to give them a certain order to
print on a report??

I'm wondering how the List Box would affect the order of printing on a
Rport? The Sorting and Grouping Properties of the Report are what
determines the order in which the Rcords are printed.

The List Box's Row Source will determine the order in which information
appears in the List Box.

Larry Linson
Microsoft Office Access MVP

Thanks Larry, So no matter what order i put them in my listbox that wont
print the prder on my report?.......Regards Bob

"Larry Linson" wrote in message
...

"Bob Vance" wrote in message
...
If I have a list box that has a row source to a query is it possible to
drag my records up and down the list box to give them a certain order to
print on a report??

I'm wondering how the List Box would affect the order of printing on a
Rport? The Sorting and Grouping Properties of the Report are what
determines the order in which the Rcords are printed.

The List Box's Row Source will determine the order in which information
appears in the List Box.

Larry Linson
Microsoft Office Access MVP

"Bob Vance" wrote in
:

Thanks Larry, So no matter what order i put them in my listbox
that wont print the prder on my report?.......Regards Bob

Having some (l)user drag records up and down randomly seems a pretty
disorganized way to sort anything. Is there no usable field such as a
name, date or id field that could be used to sort the report
sequence?

If you really need to do this, create a new field, sortorder, type
integer. You can then use some code to set this number, based on the
dragging, or up and down arrows like in some of the wizards, as the
field to sort on in the report.

Q

"Larry Linson" wrote in message
...

"Bob Vance" wrote in message
...
If I have a list box that has a row source to a query is it
possible to drag my records up and down the list box to give
them a certain order to print on a report??

I'm wondering how the List Box would affect the order of printing
on a Rport? The Sorting and Grouping Properties of the Report
are what determines the order in which the Rcords are printed.

The List Box's Row Source will determine the order in which
information appears in the List Box.

Larry Linson
Microsoft Office Access MVP