467,886 Members | 1,792 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,886 developers. It's quick & easy.

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...
Apr 3 '08 #1
  • viewed: 1286
Share:
2 Replies
ADezii
Expert 8TB
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...
Expand|Select|Wrap|Line Numbers
  1. 'Set Gocus to the Sub-Form Control
  2. Me![LicenseInformation].SetFocus
  3.  
  4. 'Add a New Record
  5. DoCmd.GoToRecord acActiveDataObject, , acNewRec
Apr 6 '08 #2
jinalpatel
Expand|Select|Wrap|Line Numbers
  1. 'Set Gocus to the Sub-Form Control
  2. Me![LicenseInformation].SetFocus
  3.  
  4. 'Add a New Record
  5. 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...
Apr 11 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by sixsoccer | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.