By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,255 Members | 2,575 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,255 IT Pros & Developers. It's quick & easy.

Select Multiple Options

P: n/a
My tables look basically like:
TblCustomer
CustomerID
Customer

TblOption
OptionID
Option

TblCustomerOption
CustomerOptionID
CustomerID
OptionID

A customer can select one to seven options. My main form is based on
TblCustomer and there is a subform based on TblCustomerOption. The main form
and subform are linked on CustomerID. In the subform I would like to show
all seven options with a Checkbox beside each option where the option(s) the
customer selected can be checked and a record is created in
TblCustomerOption for each option checked. Further, I would like to show the
options in two columns with the first four options in column 1 and the
remaining 3 options in column 2.

Can this all be done? How?

Thank you very much,

Marie
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You may find two multiselect listboxes work better than a subform for this.
"Marie" <mh*****@earthlink.net> wrote in message
news:n7******************@newsread3.news.atl.earth link.net...
My tables look basically like:
TblCustomer
CustomerID
Customer

TblOption
OptionID
Option

TblCustomerOption
CustomerOptionID
CustomerID
OptionID

A customer can select one to seven options. My main form is based on
TblCustomer and there is a subform based on TblCustomerOption. The main form and subform are linked on CustomerID. In the subform I would like to show
all seven options with a Checkbox beside each option where the option(s) the customer selected can be checked and a record is created in
TblCustomerOption for each option checked. Further, I would like to show the options in two columns with the first four options in column 1 and the
remaining 3 options in column 2.

Can this all be done? How?

Thank you very much,

Marie

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.