Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to copy data from one subform to another subform

Status
Not open for further replies.

frobo

Programmer
May 13, 2005
14
CH
How to copy data into a new record from one subform to another subform when both subs have the same form?
the names I entered for each subform on the main form are different, but they aren't accessible at runtime :(.

any ideas?
 
well...
I need to reference one subform of two (they both have the same underlying form) for the following command. I tried lot of styles :p ... :

Code:
DoCmd.GoToRecord acDataForm, Forms![subEingabeB], acNewRec
DoCmd.GoToRecord acDataForm, Forms![Startformular]![subEingabeB], acNewRec
...

what is correct?
 
Have you tried the Form_xxx syntax ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
thanks to this nice KB i found this:

Code:
Me.subEingabeB.SetFocus
DoCmd.GoToRecord , , acNewRec

which definitely does the job, hurray! :)

thanks alot PH for your fast answers!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top