Subform autonumberID 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
 
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
 
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!
 
Harmannus said:
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.
Click to expand...

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.
 
Thanx for the quick response (-;

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

Regards!
 
Back
Top