J
JString
Is it possible to programatically create a new form using another as a
template?
template?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JString
Could there be any application run commands to copy/'paste as' ?
J
JString
Nevermind.... I just found docmd.copyobject
JString said:Could there be any application run commands to copy/'paste as' ?
F
fredg
Is it possible to programatically create a new form using another as a
template?
Sure. Just copy the existing form and change it's record source and
other changes (if you wish).
' Copy the existing form
DoCmd.CopyObject , "NewFormName", acForm, "OldFormName"
' Change it's record source to a different one.
DoCmd.OpenForm "NewFormName", acDesign, , , , acHidden
Forms!NewFormName.RecordSource = "NewRecordSource"
' Make additional form changes here.... then....
DoCmd.Close acForm, "NewFormName", acSaveYes
' Open the new form
DoCmd.OpenForm "NewFormName"