J
JimS
I have a list box "lbSATrans". Its RowSource is set in VBA, It's a long SQL
query. It works fine, including the header row.
I have a combo box "cbSortOrder". Its RowSourceType is "Field List", and I
copy the RowSource from lbSATrans into the RowSource of cbSortOrder, then
requery it every time I requery lbSATrans.
My expectation is that cbSortOrder will contain the field names of the query
underlying lbSATrans, and it does. Unfortunately, when I use some of the
field names to modify the "ORDER by" clause of lbSATrans, some of those field
names are invalid, I think because they are not sufficiently qualified. The
revise RowSource for lbSATrans with the revised "ORDER by" clause returns
nothing.
How would you resolve this?
query. It works fine, including the header row.
I have a combo box "cbSortOrder". Its RowSourceType is "Field List", and I
copy the RowSource from lbSATrans into the RowSource of cbSortOrder, then
requery it every time I requery lbSATrans.
My expectation is that cbSortOrder will contain the field names of the query
underlying lbSATrans, and it does. Unfortunately, when I use some of the
field names to modify the "ORDER by" clause of lbSATrans, some of those field
names are invalid, I think because they are not sufficiently qualified. The
revise RowSource for lbSATrans with the revised "ORDER by" clause returns
nothing.
How would you resolve this?