L
lilbit27
I have a text box and the control souce says:
=fCntProdRec([Prodcd]
I have a label that I want the users to be able to click on that will
sort this text box in descending and ascending order, but I am not
show to do that when the control source is setup this way.
I had to take it out of the query that I was running where I had
xx:fCntProdRec([Prodcd]) and then I could sort by referencing the xx.
Static blFlag As Boolean
Me.OrderByOn = True
If blFlag = False Then
Me.OrderBy = "[xx]"
Else
Me.OrderBy = "[xx]desc"
End If
blFlag = Not blFlag
End Sub
but it was causing the form to load so slow and changing it to the the
above way has improved the response time. Just not sure how to sort
now.
=fCntProdRec([Prodcd]
I have a label that I want the users to be able to click on that will
sort this text box in descending and ascending order, but I am not
show to do that when the control source is setup this way.
I had to take it out of the query that I was running where I had
xx:fCntProdRec([Prodcd]) and then I could sort by referencing the xx.
Static blFlag As Boolean
Me.OrderByOn = True
If blFlag = False Then
Me.OrderBy = "[xx]"
Else
Me.OrderBy = "[xx]desc"
End If
blFlag = Not blFlag
End Sub
but it was causing the form to load so slow and changing it to the the
above way has improved the response time. Just not sure how to sort
now.