i have form1 and form2
With form1 still open when form2 opens:
In the Open event of form2:
Me.listbox2.RowSource = Form_form1.listbox1.RowSource
when i add this code in i get "openform action was canceled"
Code:
Private sub Add_click() <<< form 1
Form_form2.list2.RowSource = Me.list1.RowSource
DoCmd.OpenForm ..., Me.listbox1.RowSource
Me.comboboxname.RowSource = Me.OpenArgs
End sub
Note: listbox1 is a table/query type
lsitbox2 is value list type
how do i get rid of the error "the openform action was canceled"???