By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,282 Members | 1,669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,282 IT Pros & Developers. It's quick & easy.

Copying existing to new records on Form with sub forms

P: n/a
Forms programming not my specialty, appreciated any advice on my
direction I'm going with this.

Basic need my client has is to "clone" the existing 3 tables records
being viewed on a 3 part Form-SubForm-SubSubForm. The 3 tables will
each recieve very similar new rows with only a unique key being new to
them. My current approach:

Use a new button to trigger VBA code to build a SQL insert statement
from the existing form's controls (txt fields, cbo boxes etc..);
Insert the single new rows on each table; Force the new records to
appear on the form and display a message confirming success.

Assuming this is most efficient way, could use advice on auto-
displaying the new rows. I suspect a new SQL select-join against the
3 tbls for the new rows, and a "Screen.ActiveForm.RecordSource =
SQLText" to populate the form controls from that.

Thanks for advice, I sure like this GOOG group

Don F
@ P.S.E. in Bellevue, Wa

Sep 29 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.