P
PZ Straube
A question from a novice, please...
In a contact list FORM I have, I use two Combo Boxes. One
for last names and the other for first names. What I
would like to be able to do is base the sorting of the
records in that form on which field I pull down.
So, if for my first search I'm looking for a last name of
Smith, when I pull "Smith" down, all records that I view
on that form are sorted by last name and it starts with
those records having a last name of Smith. If I then
click on the First Name Combo Box and select the name
John, all records would be sorted by first name and John
would be the first of the first names I would see on the
screen.
Is this possible and if so, could someone point me in the
right direction for how to accomplish this? I believe I
need to have something trigger the OrderBy option on the
main form based on which combo box I use, which would then
tell it to sort on either the first name or the last name.
Thanks!
In a contact list FORM I have, I use two Combo Boxes. One
for last names and the other for first names. What I
would like to be able to do is base the sorting of the
records in that form on which field I pull down.
So, if for my first search I'm looking for a last name of
Smith, when I pull "Smith" down, all records that I view
on that form are sorted by last name and it starts with
those records having a last name of Smith. If I then
click on the First Name Combo Box and select the name
John, all records would be sorted by first name and John
would be the first of the first names I would see on the
screen.
Is this possible and if so, could someone point me in the
right direction for how to accomplish this? I believe I
need to have something trigger the OrderBy option on the
main form based on which combo box I use, which would then
tell it to sort on either the first name or the last name.
Thanks!