accending sort in a form

[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?

 

[Graham Mandeno]

Requery the form after adding the new record:
Me.Requery

 

[Guest]

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?

.

 

[Rick Brandt]

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

Use AfterUpdate, not BeforeUpdate.