Adding data to a subform

  • Thread starter Thread starter RC-
  • Start date Start date
R

RC-

Hi all,
How can I add data to a subform using VBA? I know that I can manually
enter the data, but I want to be able to click a button and populate the
data automatically. I know how to capture the data that I want to send to
the subform, I just don't know how to populate the subform with the data.


Any help is greatly appreciated
RC-
 
On the onclick event of the button you can write this code

Me.SubFormName.setfocus
DoCmd.GoToRecord , , acNewRec
Me.SubFormName.form.Field1Name=Value1
Me.SubFormName.form.Field2Name=Value2
Me.SubFormName.form.Field3Name=Value3
Me.SubFormName.form.Field4Name=Value4
 
Excellent, thank you.
Ofer said:
On the onclick event of the button you can write this code

Me.SubFormName.setfocus
DoCmd.GoToRecord , , acNewRec
Me.SubFormName.form.Field1Name=Value1
Me.SubFormName.form.Field2Name=Value2
Me.SubFormName.form.Field3Name=Value3
Me.SubFormName.form.Field4Name=Value4
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Data Entry Setting 0
Problem with form--subform 5
Please help - I need to separate data to two tables using one form. 0
Updating tables when you input new data 0
Retrieving data from subform 1
Sometimes GotFocus event doesnt occur on subform...strange 1
After Update event on form inputting data into a subform? 2
mirror data from subform to main form 3

Back
Top