Linking combo box and filter

[shy216]

i've linked 2 cbo boxes from different forms.
so from form 1 if user selects OK, it opens form 2
and that record shows up on form 2 as well.
problem is i need to show different column on the form 2.
i.e. if first combo box contains 2 colums,
"Name", and "Number". (but only shows "name" from
form 1). when user selects from cbo and clicks ok.
then Form 2 opens up and on that cbo, "number"
needs to show up.
does that make sense? so pretty much second one must bring
all the info from the first cbo but only show different column as the first cbo.

 

[iamthebestuk]

use the column width functionality in the properties section of the form design and set it to something like 2;0 where 0 is the colum you want to hide.



Power is Knowledge
Knowledge is Power