capturing multiple values

itsozzy2003

New member
Local time
Today, 11:03
Joined
Sep 23, 2010
Messages
2
Hi Guys,

I have hit a brick wall and hoping someone can help me. I am fairly new to access. I am working on designing a form, a section in the form needs to capture information if the customer has other suppliers.

So I have a question in my form "does the customer have other suppliers?", If the user selects yes by ticking the tick box, i want a list box to populate with a list of 7-8 suppliers e.g ABC,BBC,CBC,DBC,EBC,FBC,GBC. now i want to users to be able to select multiple supliers but i am not sure how to capture the details of these multiple supplier.

So when we run a query like show me who are the supliers for customer John Smith, it should display all the suppliers.

Any assistance is greatly appreciated.
Cheers,
Oz
 
Thanks for the quick reply pbaldy, but i am quite confused with the example you gave me, and my coding knowledge is zero. could you or somebody mock an example based on my scenario i.e with the supplier list.

so when some tick the box for does the client have other supplier they can select multiple supplier from a list box and store those value is a table.

your assistance is highly appreciated.
 

Users who are viewing this thread

Back
Top Bottom