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.ActiveF orm.RecordSourc e =
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
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.ActiveF orm.RecordSourc e =
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