data entry form for many to many relationship

[awa786]

Hi all,
I want to know that what is the best way to make the data entry form for many to many relationship tables without the sub-forms. i want to use single form for entering data into the multiple linked forms.
thanks and regards.

 

[CJ_London]

simple answer is you can't without subforms, at least not without a huge amount of coding to cross reference all the forms.

 

[MarlaC]

simple answer is you can't without subforms, at least not without a huge amount of coding to cross reference all the forms.

This is exactly right. If you want to do it, you'll need to use unbound controls and VBA to populate recordsets to achieve this. If you're not a sufficiently advanced user to be comfortable with those, then I would suggest either resigning yourself to subforms or popping up a chain of forms to get the data from the user.

 

[awa786]

Thank you both for the suggestion ,This is the good idea and now i am going to making unbound form to achieve this..

 

[The_Doc_Man]

I'll second the opinion that if you really want a many-to-many relationship handed by a form, create the M-M entry via an unbound form with two different ROWSOURCE queries, one for each of the tables. Then some VBA code will let you determine which rows are selected for each of the list boxes and you can do an INSERT INTO query that you build programmatically to create the M-M joined records.