i have Product form,
on that form i have one button,
when user click on this button,
Order form open with new record and Default value
and OrderSubform Populate with Product, which is currently on Product form.
Problem is OrderSubform not got focus and how populate OrderSubform with product on product form?
[I have write below code on OnLoad Event of Order Form]
Code:
Private Sub Form_Load()
Me!OrderSubform.Form!cmbProductID.SetFocus
DoCmd.GoToRecord , , acNewRec
txtOrderDate.Value = Date
txtFinishedDate.Value = Date
txtRequiredDate.Value = Date
cmbCustomer.Value = 1
cmbEmployee.Value = 1
End Sub
Product form.
what i have tried => [here Download Project]