Aesthetics problem

[GS1]

My database is used to track the firm's activities - I use different forms for each different type of activity to simplify data entry.

Many of my forms contain a subform that allows users to input the names of employees involved in a given activity - The subform looks up users from the Users table and places the data into a employees involved junction table.

My problem is that quite often 20+ employees may be involved in an activity. The subform that I use is in datasheet view, but goes on for miles vertically on the page when there are so many entries.

I do not want to use a tabbed form, but could use a pop up subform (if someone could let me know how to set it up) and am willing to try out any other aesthetically pleasing ideas anyone can come up with...

G

 

[Hayley Baxter]

Have a look at the example in this post. I think this is what you mean.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=33706

Hay

 

[GS1]

Perfect

Thanks you!