Combo-box: One & One only Selection

[andrebmsilva]

Hello,



I have this doubt about Comboboxes:

How can I have data sheet subform where there is a combobox with a list of options that each time i select one option it wont appear in the combobox of the next row and the next subforms? What i really want is to be able to combine several Unique items in a basket.

I have tried Querys and Update Querys, but as I'm new to MS Access, I wasn't able to figure it out.

Thanks in advance
André

[msoffice.vidyarthi]

Let me get this straight.

Suppose a,b,c,d,e,f,g,h,i is the list that has to go into comboboxs

if u select 'a' in first combo, then other combos should not have 'a' showing in them.
like wise if u select b in 2nd combo, then other combos should not show 'a' and 'b' and so on

is that what you want

[andrebmsilva]

Yes, that's exactly what i need.

My teacher suggested using 2 tables. One table for the basket and other table for the items and link them as "One to many". Then he said that using a query that searches for "Null" in the foreign key should make a solution.

Do you think that's possible?
Thanks

[msoffice.vidyarthi]

It will be easy for me to try to resolve if you provide me with sample db, as it would be very tedious for me to recreate all the things that you are doing at your end. try to zip it and send the db

[andrebmsilva]

Here it is... Thanks

[msoffice.vidyarthi]

Here,s the picture.

You are trying to select data from the same table yet filtering the same. Same where I guess you need to rethink about you linking of the table.

Or else the data source of the combobox is not set correct

Question: is the data source of combobox set right to "SELECT Carpet.IDCarpet FROM Carpet; "

Try inserting data into subform in FormView and c the error msg

[qa12dx]

Attachment 10089

here u go. hope it helps

[andrebmsilva]

thank you so much. this is really what i need!

Attachment 10089

here u go. hope it helps