output table in a form using vba

[Rockape]

Hi all, grateful for some help,


I have a table of persons many of which belong to different departments.

I have a main form with a combo from which I can select from a list of departments.

my question.. how can I produce a list as either a table or a form which responds to my choice. i.e all the persons belonging to the same department and which I can embed on that same main form?

I'm using A97 and I'd like to know how I can do this using vba

Regards

 

[JBurlison]

Make a Query see my post here

http://www.access-programmers.co.uk/forums/showthread.php?t=147161