HELP! How to construct a data entry form from a junction table?

[Guest]

I have a couple of many-to-many relationships in my database. Now that I
have come to form design for data entry, I don't know what to do. I am
assuming that I must populate the junction/link table not the category table.
How do I do this on a data entry form?

I want it to have the look and feel of selecting more than one
item?......For this, I'm assuming you need code--which I don't know. The
other way is a subform with a combo box where the user selects many items (1
per line)--o.k. but I rather have the former.

Thanks in advance.

 

[Sandra Daigle]

Take a look at my SelectRecords sample database:

http://www.daiglenet.com/msaccess.htm

This sample shows how to do it with a main form/subform approach as well as
how to do it with a pair of multiselect listboxes.