How to add record to the subform while keeping the mainform data as it is

[jinalpatel]

I have a mainform which contains "Holder Information (name,address,dob etc)
and within this mainform a subform called "LicenseInformation" (licensetype,purchasedate,amount etc)

When user search the holder information in mainform, he can see his personal info in mainform and license info in subform.

What I want is: When the user click the command button "Add license info",
the user should be able to write into the grid shown in the subform.(still the personal info shd be shown in mainform)

OR is there any other way to do this??
Please help..I am a novice to VBA...

[ADezii]

I have a mainform which contains "Holder Information (name,address,dob etc)
and within this mainform a subform called "LicenseInformation" (licensetype,purchasedate,amount etc)

When user search the holder information in mainform, he can see his personal info in mainform and license info in subform.

What I want is: When the user click the command button "Add license info",
the user should be able to write into the grid shown in the subform.(still the personal info shd be shown in mainform)

OR is there any other way to do this??
Please help..I am a novice to VBA...

'Set Gocus to the Sub-Form Control
Me![LicenseInformation].SetFocus
 
'Add a New Record
DoCmd.GoToRecord acActiveDataObject, , acNewRec

[jinalpatel]

'Set Gocus to the Sub-Form Control
Me![LicenseInformation].SetFocus
 
'Add a New Record
DoCmd.GoToRecord acActiveDataObject, , acNewRec

Thanks for your help...Actually There is some change in rquirement and now I have to create a new form which accepts all the info at a time...