Combobox to combobox

[HansD]

hello everybody

I have a small question:

i have a form with a subform
on the main form i have a combobox(Cbo1)
on the child form i have a combobox(Cbo2)and a button

now i want to pass the data from Cbo2 to Cbo1 when i press the button, the comboboxes should be exactly the same

Tnx

Hans

 

[TheAceMan1]

How are ya HansD . . . . .

In the [blue]OnClick event[/blue] of your button try (you substitute proper names in [purple]purple[/purple]):

[blue]Forms![purple][b]MainFormName[/b][/purple]![purple][b]Cbo1Name[/b][/purple].RowSource = Me![purple][b]Cbo2Name[/b][/purple].RowSource[/blue]

See Ya! . . . . . .

 

[HansD]

Tnx for your reaction TheAceMan1.

I will try it tommorrow because i have to go now.
I will let you know how it worked out


Hans