combobox

[Andy]

Hello
I have 3-Tables
1: ItemList: 2:SubCodeList:
Item# ItemName Item# SC# Station . . .
1 Earth 1 1 10+00
2 Dravel 1 2 12+00
.. 2 1
.. 2 2
60Items . .
Look from Tb:1 Each Item Has 100
SC#

3: SubCodeList: Item# SC# .....Both these col. has combobox. Item#
will be seen from Tb:2 and SC# will be seen TB:2. I need to write criteria
for SC# bombobox so that it list only those SC# for The Item selected in
Itemfield of this Table:3. I don't wanna see all SC# otherwise I have to
scroll too many records!!!!
How would I do this?
ANDY

 

[S.Clark]

Access has a real problem with this, especially in a datasheet view when
trying to implement a dependent combobox.

Reason being is that after you select the item#, you want to restrict the
SC#'s that show in it's cbox, by changing the rowsource. When you do this,
it causes all the other rows to go 'blank', as their assigned value may not
exist in this new restricted subset.

So, you could implement a popup form to allow the user to select the Item
and SC for that current row. There are about 4 other ways to try to skin
this cat, but it really depends on what you've already promised the user, and
what your Access & VBA skills are.