Copying existing to new records on Form with sub forms

[don.fleming]

Greetings,
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