Afterupdate

[Charlie]

1) how do I get the values in a combobox box to sort by
its value (ascending)? I was using the DISTINCT functino
up until now since it just happens to also filter out
repeated values for me. But for some reason, it's now not
working. I think it has to do wtih my where statement.
Can someone help me find a way to sort my values
alphabetically or numerically?

2) Me!Combo2.Requery does not work when I enter it into my
combo1 afterupdate. Instead when combo2 is clicked
on "form!FormName!Combo" appears and I need to basically
manually enter the value I had clicked on in combo 1.
When I click on combo1, I want it to automatically limit
the values in combo2. For instance I have 96 records in
one source. But by previously clicking on combo1, combo2
will show only about 5-10 results.

Please help!

 

[Dan Artuso]

answered in either forms or formscoding, can't remember which.
hope you do

 

[Wayne Morgan]

1) You need an Order By clause in the query. Try copying and pasting your query into a new
query grid that has been opened in SQL view. Open the query and see what you get. Now open
the query in the design grid and set the Order By on the field you want. If you wanted
sorted by more than one field, they will be sorted in left-to-right order.

2) "form!FormName!Combo" - typo, try forms!FormName!Combo or if on the same form Me!Combo

 

[HSalim]

thats evil

answered in either forms or formscoding, can't remember which.
hope you do

 

[Dan Artuso]

Well maybe just a touch, it's been one of those days