Subform 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

 

[Harmannus]

Thanx for the response!

If i do this i cannot add persons on the form Activity with the subform
ActivityPersons!

Maybe i am doing something wrong?

 

[Harmannus]

Hallo,

Thanx for the respons!

Figured it out (-;

As suggested by you i now use a query for the subform ActivityPerson (with
the fields AcitvityID and PersonID). If i select the PersonName as the
sortfield and uncheck it i am able to add persons in the Activity form with
the ActivityPerson subform on it. With the PersonName checked i was not able
to add persons.

Thanx for the help!

Regards