open form based on combobox

[bigmac]

hi all, can you help please, i have two forms "form1" and "form2", on form one i have cascading combobox called "cbo27", what i am trying to do is after update of "cbo27" than this will open form2 and place the contents of "cbo27" into a textbox called "isodwgno", can anyone help please, cheers

[pbaldy]

After opening the form:

Forms!Form2.isodwgno = Me.cbo27

[TG_W]

Try the following

Private Sub cbo27_AfterUpdate()
DoCmd.OpenForm "Form2"
[Forms]![Form2]![isodwgno] = Me.cbo27
End Sub

[bigmac]

thanks for the fast response, will try them out, thanks