Newbie SubForm Question

[LOUM]

Good Day,



I have a subform I want to place on my form that shows and filters all the vendors I have in my database. I want to put a check box next to the vendors that the user has selected as relationable to the content they are filling out on the parent form.

A. How should I relate the subform to the tblVendor for the user to choose the vendors?

B. The resulting choices will then save to my main form table or a vendor selection table (normalization)?

Thank you,

LOU

[June7]

Don't understand what you are trying to do. What is purpose of this form? What is the main form RecordSource? We need to know more about data table relationships and structure. Do you want to provide db for analysis? Follow instructions at bottom of my post.

[AccessMSSQL]

Lou, it sounds like you have a main form that user is entering data in that is bound to your main table. What you need to do is create another table called tblVendorsSelected (or whatever you want to call it). This table should have a foreign key that relates back to the main table primary key. If you add a subform that is bound to the new table to your main form and set the proper child/parent fields you should be able to have your users enter vendors directly in the list. In order to have a check boxed list you will need to load your vendors list into a temporary table that has a checkbox field in it and open this table in another form for your users to select from. You will have to clear that table and re-load the records each time. I will upload a sample for you shortly in my next post.

[AccessMSSQL]

Attached is a sample database with the functionality you need. This is pretty rudimentary - so there is no error handling. Just take a look at frmMainTable for the sample. Hope this helps!

[LOUM]

Thank you both. I am new and this helps tremendously.

Lou

[LOUM]

How do I mark the thread as complete?

[June7]

Under Thread Tools on menu bar above first post.

[LOUM]

Thank you.