Combo box

  • Thread starter Thread starter Lachie Thomas
  • Start date Start date
L

Lachie Thomas

Hello,

I am creating a website that uses a shopping cart with an
access database. The user has an option to add an item to
a cart they can select how many and what colour. Then add
to cart. As each product has a different colours to choose
from I am having trouble creating a combo box in access
that only displays the colours of the corresponding. Would
anyone know how it would be possible to create a combo box
that lists imformation only specific to that row. I can
create a combo box that lists values for all the rows but
this is not really what I want.

Any help would be fantastic

Lachie
 
If you are going to do this, make each record be displayed on a seperate
form. Otherwise, when you dynamically change the rowsource(let's say in a
datasheet view) then the other data in that same column will be blanked out
temporarily. Big pain.

So, when the user wants to edit the record, they can place the cursor in
that row, and click an edit button. Next, open the edit form, and populate
the color combo based on the product type, or whatever criteria is used.
Since there is only one combo, you'll have no problems.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top