When I "ORDER BY" my list disappears... 2

[JonWolgamuth]

I have a sequel statement assigned to

mstrSQL

and when I call for it using this code

Me!WorkToDoLST.RowSource = mstrSQL

everything in my list box shows up okay. However, if I try to add a sort, such as

Me!WorkToDoLST.RowSource = mstrSQL & "ORDER BY DateIn DESC"

my list disappears. I can't find the problem.

Thanks in advance for any advice anyone can give me!

JW

 

[jebry]

Hi!

I can't say if this is the problem or not but shouldn't you have a space before the Order?

hth
Jeff Bridgham
bridgham@purdue.edu

 

[JonWolgamuth]

Hi again, Jeff. Thanks for your response. For some reason (I'm sure it is because I copied the line), I do have a space before the ORDER. What purpose does that space serve?

L8R,

JW

 

[jebry]

Hi!

Access will concatenate string exactly as they are so, without the space, the word Order and whatever word ends the original string will be placed together.

BTW, I had another thought. Does the string for the original row source end in a ;? If it does that may be the cause of the problem.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[JonWolgamuth]

Jeff,

One word...Bingo!

Thanks yet again!