Combo box question

[elvin_08]

i have a table PC name and borrowing form

then the PC name having a field "PC NAME" and "PC LOCATION"

then in the borrowing form i have a combo box look-up for the PC location ="COMPLAB1" "COMPLAB2"

is it possible that if i select COMPLAB1 all PC NAME that are locate in COMPLAB1 can appear in combo box or list box?

THANKS IN ADVANCE

 

[John Big Booty]

What you are looking for is a Cascading Combo Box set. Search this forum and Google for further discussion and examples.