Multiple Selections write record for each selection
Our purchasing department wants a database created based on multiple vendor's contacts selected. I have created the form that they are requesting but I am not sure how to create a drop down list to select the vendors, then have the form list the contacts associated to the vendors selected. The purchaser than can select the contacts they want to email and have the form save each record in the database by vendor.
I know I can use a list box with multi select set to simple or extended and use duplicate record but how do I duplicate by the vendor selected.
Hopefully this makes sense.....
Attached sample would be great!!
I know I can use a list box with multi select set to simple or extended and use duplicate record but how do I duplicate by the vendor selected.
Hopefully this makes sense.....
Attached sample would be great!!
set the rowsource of the cboVendor to
Select VendorID, VendorName from tblVendors
set the following properties of the combo
Column Count 2
Bound Column 1
Column Widths 0";1"
Select VendorID, VendorName from tblVendors
set the following properties of the combo
Column Count 2
Bound Column 1
Column Widths 0";1"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Some really good examples! It is a many to many relationship. The purchaser wants to be able to select multiple vendors then select multiple contacts for those vendors to email RFQ's to. Then the main RFQ file needs to be updated by the number of vendors selected so there is only one RFQ form filled out but a record written for each vendor selected.
Just making sure that I'm following...
Your structure looks like this:
Main (RFQ - one) -----> Vendors (Many/RFQ) ----> Contacts (Many per Vendor)
So your mainform (RFQ) would have a child form (Vendors) and a 'grandchild' form (Contacts)
Take a look at the sample and the solution posted by the Original Poster in this thread:
https://www.experts-exchange.com/questions/27512608/2nd-and-3rd-Sub-Sub-Form-Not-Working.html
Your structure looks like this:
Main (RFQ - one) -----> Vendors (Many/RFQ) ----> Contacts (Many per Vendor)
So your mainform (RFQ) would have a child form (Vendors) and a 'grandchild' form (Contacts)
Take a look at the sample and the solution posted by the Original Poster in this thread:
https://www.experts-exchange.com/questions/27512608/2nd-and-3rd-Sub-Sub-Form-Not-Working.html
ASKER
Mbizup, als315. It looks like the example that als315 provided would work because of the query to select a Vendor than select the email, select another vendor then select email, and so on. Now, on to figuring out how to create a duplicate RFQ record for each vendor selected and then create an email for each contact....
Can you show example of expected RFQ record?
ASKER
I'm still working on closing this question but because of my lack of knowledge with VBA I'm stuck.
How do I create a simple loop to loop through a query that is based on selected contacts and print an email for each. I have been able to get Access to do the emails with atachments but because I'm not familiar with VBA I think I'm confusing the system reserved words with what to use: exp. I see that people are using: Dim db As DAO.Database Dim rs As DAO.Recordset etc.....
How do I create a simple loop to loop through a query that is based on selected contacts and print an email for each. I have been able to get Access to do the emails with atachments but because I'm not familiar with VBA I think I'm confusing the system reserved words with what to use: exp. I see that people are using: Dim db As DAO.Database Dim rs As DAO.Recordset etc.....
ASKER
I thought I closed this. Thanks all!
* in the after update event of the combo box (cboVendor) set the rowsource of the listbox
private sub cboVendor_afterupdate()
dim sql as string
sql="select contacts from tblVendor where vendorId= " & me.cboVendor
me.lstContacts.rowsource=s
end sub
post back if you have any question..