Combo box Selections

  • Thread starter Thread starter Robbie
  • Start date Start date
R

Robbie

Hi
I have three combo boxes from a table called tbl_CUSTLDDNLD

tbl_CUSTLDDNLD
A B C
ChlRef -Plant - Item
LLL309 AAA 14285
LLL309 AAA 14265
LLL309 BBB 14270
LLL310 AAA 14285
LLL310 BBB 14270
LLL310 CCC 14281

I would like BOX B to only show data applicable to the
selection in box A so if LLL309 is selected then box b
will show AAA and BBB and from that selection say AAA Item
14285&14265 will be available for selection in BOX C.

this is to be out into a form which will update a new
table.

many thanks
Robbie
 
Go to the properties for cbo box B: its RowSource should be a query (click on
the build button) that includes both the column it shows and the column from
cbo box A. Use the Criteria row to narrow down the list of options shown by
typing an expression like: Forms!formname!cboBoxA under the column of entries
from Col A (this will then only show entries that match the current entry in
cbo box A). To cut out duplicates, make the query a group query (with the
sigma button). To cut out blanks, type a criterion of Is Not Null under the
B column. You can decide which columns are shown with the Show boxes and
with the column widths back in the cbo box's properies but make sure the
Bound column is the column you actually want the cbo box to return.

Then do the same with cbo box C, based on B this time.

Good luck!
 
Back
Top