Subform sorting?

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

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
 
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?
 
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
 
Back
Top