combo box in continuous form

[joyaccess1]

Hi,
I have a continuous form datasheet, one of the field in the continuous form is a combo box, when i click on the combo box i need the list of values that are not already selected in the previous rows.

for example : if the combo box initially has value "a", "b", "c" from a table, if i select "b" in the first row i need the combo box in the second row to only display "a" & "c"......and if select "a" for the second row, the combo box in the third row need to only display "c".

what do i need to do to achive this ?

the values in the combo box are from the table ("a","b","c" in the above example)

Thanks for the help
Joy

 

[ajetrumpet]

Hi,
I have a continuous form datasheet,

for example : if the combo box initially has value "a", "b", "c" from a table, if i select "b" in the first row i need the combo box in the second row to only display "a" & "c"......and if select "a" for the second row, the combo box in the third row need to only display "c".

When you say "rows", if you're referring to the different records displayed by the form, you can't accomplish this. You'll have to redesign the form if you want to do it.