Open Subform , Populated with value on Calling form.

[pritesharyan]

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]

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]

[ranman256]

Since the subForm is a child record,you cannot populate until you save the master record.
Save the Master record. THEN you can add child records.