accending sort in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a table of names, sorted in an accending order.
I have a form for this table, to make it easuer for the
user to add new names.

I want to keep the table sorted, because I have a combo
box in other form of those table, and I want the users to
see the names in an accending order.

How can I keep the table sorted after the user adds a new
name?
 
I wrote this in the "BeforeUpdate" function of the form
and tried also in the field itself, but when running,
there is a run time error - 2115
-----Original Message-----
Requery the form after adding the new record:
Me.Requery

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hello,

I have a table of names, sorted in an accending order.
I have a form for this table, to make it easuer for the
user to add new names.

I want to keep the table sorted, because I have a combo
box in other form of those table, and I want the users to
see the names in an accending order.

How can I keep the table sorted after the user adds a new
name?
Click to expand...


.
Click to expand...
 
I wrote this in the "BeforeUpdate" function of the form
and tried also in the field itself, but when running,
there is a run time error - 2115
Click to expand...

Use AfterUpdate, not BeforeUpdate.
 
Back
Top