copy info in subform as well as main form

09-30-2009, 08:02 AM

Coolpapabell Coolpapabell is offline

Windows Vista Coolpapabell uses Access 2007 (version 12.0)

Access 2007 (version 12.0)

Novice

Join Date: Jul 2009

Posts: 19

copy info in subform as well as main form

I have a form for style reference with a linked subform with color and labeling choices available for that style.

I used the same docmd statements that comes up with the duplicate record button wizard to start a copy of the record listed below.

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdRecordsGoToNew
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdPaste

Is there a way to copy the subform data as well?

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are Off Pingbacks are On Refbacks are On Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Controls for subform on Main Form not working	jonsuns7	Forms	1	09-28-2009 03:21 PM
Populate subform that adds records based on main form	tigers	Access	0	06-23-2009 01:01 PM
Hide & unhide subform based on criteria of combo on main form	KLynch0803	Forms	6	06-03-2009 12:01 PM
Main Form ComboBox to Filter Records in SubForm	shiwawa	Forms	7	05-24-2009 08:24 AM
Subform vs main form calculation	fadone	Forms	17	12-21-2005 04:27 AM

All times are GMT -8. The time now is 01:31 PM.