a form of a table

  • Thread starter Thread starter Liat
  • Start date Start date
L

Liat

Hello,

I have a form (form 1) of a table with names.
There is another form (form 2) that has a combo box which
it's source is that name's table.
In order to make it easier for the user to add names to
the name's table, I built this form (form 1).
The problem is that I want the names in the combo box to
appear in an alphabetic order.
What is the order I need to use in order that after the
user enters a new name, it will be sorted in alphabetic
order?

Thanks a lot,
Liat
 
Liat said:
I have a form (form 1) of a table with names.
There is another form (form 2) that has a combo box which
it's source is that name's table.
In order to make it easier for the user to add names to
the name's table, I built this form (form 1).
The problem is that I want the names in the combo box to
appear in an alphabetic order.
What is the order I need to use in order that after the
user enters a new name, it will be sorted in alphabetic
order?
Click to expand...

To get the combo box's list sorted by the lastname field,
set its RowSource to a query that specifiess the dorting you
want. Maybe something like:

SELECT nameID, lastname FROM namestable ORDER BY lastname

I don't fully understand the second part about form2 getting
invloved. Maybe you have bothe forms open at the same time
and want changes to the list in form1 to be immediately
effective in the combo box on form2? If so, then form1
needs to check to make sure that form2 is actually open and
if it is, then Requery the combo box in the AfterUpdate of
the name control in form1.
 
Back
Top