Subform autonumberID sorting?

[Harmannus]

Hallo,

I have a subform based on a table with autonumberID fields. How can i sort
the entries in this subform automatically based on "name" field from the
table used in this subform.

Explaination:

tblPerson:
PersonID
PersonName

tblActivity
ActivityID
ActivityName

tblActivityPerson
ActivityID
PersonID

frmActivity with subform based on tblActivityPerson

Subform ActivityPerson contains field PersonID

Thanx in advance for any responses!


Greetings,

Harmannus, The Netherlands

 

[chas]

Hi Harmannus,

use a query as the basis of the subform instead of a
table. You can then sort the query on whatever field you
need.

hth

chas

 

[Harmannus]

Hallo,

That will not work in this case as the subform is used for input. Meaning
adding persons to a activity. After adding people i want them sorted
automatically.

Any suggestions?

Regards!

 

[Rick Brandt]

Hallo,

That will not work in this case as the subform is used for input. Meaning
adding persons to a activity. After adding people i want them sorted
automatically.

Yes it will. You just need to issue a Requery to the subform after the entries are
made. They should then sort according to the underlying query.

 

[Harmannus]

Thanx for the quick response (-;

How do i accomplish this: vbcode after the before update event? e.g.
me.requiry?!?

Regards!