Combo Box Row Source Ordering

[Marnie Parker]

I am adding a drop down comb box to an existing database I wrote about a year
ago. This combo box list names where the user can select which record to go to.

Sigh.

Last, First Name and a hidden key field. I've got everything working, and have
it on different forms. Created a routine to set it to SELECT the right fields
for the right table for the right forms. I also have it successfully ordering
by.

I mean the user can sort the last name field, descending. So I want the drop
down list to be descending too, when they use it. Works fine WHEN THE FORM IS
OPENED. I can trim the form's order by and add on "ORDER BY " to the SELECT
statement to for the combo box's row source.

But, big but, it only works when the form opens, because they can resort the
last (or first name field) after opening. Which means the drop down combo box
will then be out of order. Not a big problem, but I would like it to match.

Is there any way to detect when someone sorts? I haven't found any such event.

Also, when the form opens, the box is blank. It only picks up a default name
after one drop down and selection. I'd like it to fill in with the first record
that comes up.

HELP!!!

Any help appreciated, this is driving me nuts.

Doe :-)
do*******@aol.c om
IF http://members.aol.com/doepage/intfict.htm
(An Iffy Theory | Glulx/Glk for Duncies | unglklib | Inform Primer)
IF Art Gallery http://members.aol.com/iffyart/
IF Review Conspiracy http://zork.plover.net/~textfire/conspiracy/

[Bob Quintal]

do*******@aol.c om (Marnie Parker) wrote in
news:20******** *************** ****@mb-m13.aol.com:

I am adding a drop down comb box to an existing database I
wrote about a year ago. This combo box list names where the
user can select which record to go to.

Sigh.

Last, First Name and a hidden key field. I've got everything
working, and have it on different forms. Created a routine to
set it to SELECT the right fields for the right table for the
right forms. I also have it successfully ordering by.

I mean the user can sort the last name field, descending. So I
want the drop down list to be descending too, when they use
it. Works fine WHEN THE FORM IS OPENED. I can trim the form's
order by and add on "ORDER BY " to the SELECT statement to for
the combo box's row source.

But, big but, it only works when the form opens, because they
can resort the last (or first name field) after opening. Which
means the drop down combo box will then be out of order. Not a
big problem, but I would like it to match.

Is there any way to detect when someone sorts? I haven't found
any such event.

Also, when the form opens, the box is blank. It only picks up
a default name after one drop down and selection. I'd like it
to fill in with the first record that comes up.

HELP!!!
The sort issue can be resolved if you use a sort button on the
form, but not the sort buttons on the toolbar. All you need to do
is send the new sort order in the same way you do at form opening
and then mycomboboxname. requery.

for your second issue, you can preset the combobox from the
form_current event by setting its value to the key value of the
current record in the form

Bob Q.


Any help appreciated, this is driving me nuts.

Doe :-)
do*******@aol.c om
IF http://members.aol.com/doepage/intfict.htm
(An Iffy Theory | Glulx/Glk for Duncies | unglklib | Inform
Primer) IF Art Gallery http://members.aol.com/iffyart/
IF Review Conspiracy
http://zork.plover.net/~textfire/conspiracy/

[rkc]

"Marnie Parker" <do*******@aol. com> wrote in message
news:20******** *************** ****@mb-m13.aol.com...

Is there any way to detect when someone sorts? I haven't found any such

event.

Use the Form's On Current event to check the Form's OrderBy property.

[Marnie Parker]

>Subject: Re: Combo Box Row Source Ordering

From: Bob Quintal bq******@genera tion.net
Date: 11/7/2003 6:52 PM Pacific Standard Time
Message-id: for your second issue, you can preset the combobox from the
form_current event by setting its value to the key value of the
current record in the form

Bob Q.

Thanks! I'll try that.

Doe :-)
do*******@aol.c om
IF http://members.aol.com/doepage/intfict.htm
(An Iffy Theory | Glulx/Glk for Duncies | unglklib | Inform Primer)
IF Art Gallery http://members.aol.com/iffyart/
IF Review Conspiracy http://zork.plover.net/~textfire/conspiracy/

[Marnie Parker]

>Subject: Re: Combo Box Row Source Ordering

From: "rkc" rk*@yabba.dabba .do.rochester.r r.bomb
Date: 11/7/2003 9:24 PM Pacific Use the Form's On Current event to check the Form's OrderBy property.

Already do that. Only good for when form is opened. I can set the row source
sort then based on the orderby. Not good for when they sort after opening.

I used Access to write this database (been programmer in other "languages" ),
but it is just this sort of thing -- not having true event tracking -- can't
tell *when* a user sorts or resorts -- that has seriously turned me off it.

Not that there is a lot better out there for small business database
development.

I've decided to live with it the way it is, the sort in the combo box won't
match the record sort, if the user resorts after opening the form. Not a
biggie, just annoying.

Thx anyway.

Doe
do*******@aol.c om
IF http://members.aol.com/doepage/intfict.htm
(An Iffy Theory | Glulx/Glk for Duncies | unglklib | Inform Primer)
IF Art Gallery http://members.aol.com/iffyart/
IF Review Conspiracy http://zork.plover.net/~textfire/conspiracy/

[rkc]

"Marnie Parker" <do*******@aol. com> wrote in message
news:20******** *************** ****@mb-m23.aol.com...

Subject: Re: Combo Box Row Source Ordering
From: "rkc" rk*@yabba.dabba .do.rochester.r r.bomb
Date: 11/7/2003 9:24 PM Pacific

Use the Form's On Current event to check the Form's OrderBy property.

Already do that. Only good for when form is opened. I can set the row

source sort then based on the orderby. Not good for when they sort after opening.

All you have to do is extend what you are already doing a tiny bit.

The current event is fired each time the form is sorted.

The OrderBy property is changed each time the form is sorted.

If you store the current OrderBy property in a form level variable when
the form opens you can then use the On Current event to compare the
stored value to the current OrderBy property. If they are not the same
then you know the form has been sorted and can determine how it
has been sorted.