Combo Box Confusion

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

If I have combo box that ia connected into a table. Now
what do i have to do to make the objects that I have in
the combo box coincide with the others. For example, I
have one combo box that when I choosed 40 Element, I want
the next combo box to be This particulat number 52W12227-
1. H
 
Mike,

In general it is not a very good idea to use tables
directly as source for your combo boxes (unless they are
parameter tables built exactly for the purpose). Mostly it
makes good sense to use queries for this, so you can (a)
get single values where some are repeated in a field, (b)
sort, (c) restrict value selection according to other
selections (your case) etc.
On your problem: make the second combo read from a query
that uses the selection of the first combo to filter (in
the query criteria line:=Forms![MyForm]![Combo1]), and use
the On Change event of the first combo to Requery the
second through a macro (action Requery, control Combo2) or
code (docmd.requery "Combo2").

HTH,
Nikos
 
Back
Top