Combobox row to equal another combo box row

[djfuego]

Hi Again.



I have 2 comboboxes each with value lists. I want combobox 2 to equal the same selected row as combo box 1 I have managed to code some VB script to select combobox 2 but need to select the same row that combobox 1 is set to.
It's not pulling the data from combobox 1 just what row is selected.


Something like this but line 2 won't work
Forms!MainInput!Comboan2.SetFocus
Forms!MainInput!Comboan2.RowSelect = Comboan1.ListIndex

[pbaldy]

Try just the last line, but use the Value property of both.

[djfuego]

Try just the last line, but use the Value property of both.

OK so the line now reads
Forms!MainInput!Comboan2.Value = Comboan1.Value


No that just copies the same info from one box to the other. I want to pick the same line in combo box 2 that combo box 1 is set to but display the data for combo box 2 which is different from combo box 1.

[pbaldy]

Sorry, I don't really understand what you're saying.