Append to table from a form

[Mikey1987]

Hello everyone,

I'm kind of new to access, and I have a question that is probably no challenge to any of you
The problem is the following...

I have 3 tables:


1) an Invoice table
2) a table with all kinds of material (approx. 10k rows)
3) a junction table with Invoice_ID and Material_ID

Now, I start the process in my Invoice Form. I have a button there to open a Material form, where I can lookup the Material_ID that I want to add to my invoice form.
But I can't seem to find out how, once I select the record I need (with the Material_ID on the row), how I can append this to my junction table.
The open Invoice form has the Invoice_ID and the active row in my Material form has the Material_ID, but how do I proceed?
I know the answer is close but I can't seem to figure it out

Thanks in advance!
Mikey

[pbaldy]

If more than one material:

http://www.baldyweb.com/MultiselectAppend.htm

If not, you can drop the loop and just refer to the 2 controls.

[Mikey1987]

If more than one material:

http://www.baldyweb.com/MultiselectAppend.htm

If not, you can drop the loop and just refer to the 2 controls.

That seems to be working perfectly
Now I just have to figure out how to implement that in my database, but at least I know "the guts" as he put it ^^

Regards,
Mikey

[pbaldy]

No problem and welcome to the site by the way! post back if you get stuck.

[June7]

Instead of a popup form, did you consider a combobox on the invoice form for selecting material? Review http://allenbrowne.com/ser-32.html