L LB79 Registered User. Local time Today, 05:00 Joined Oct 26, 2007 Messages 505 Jan 23, 2008 #1 Hello, Does anyone know what the code would be for an open form to save itself? Thanks
chergh blah Local time Today, 05:00 Joined Jun 15, 2004 Messages 1,414 Jan 23, 2008 #3 DoCmd.Save acForm, form_name_as_string
L LB79 Registered User. Local time Today, 05:00 Joined Oct 26, 2007 Messages 505 Jan 23, 2008 #4 Its the form not the record... With DoCmd.Save acForm, form_name_as_string How would I type this if my form were called FORM1? Ive tried a few things and its debugging me. Thanks
Its the form not the record... With DoCmd.Save acForm, form_name_as_string How would I type this if my form were called FORM1? Ive tried a few things and its debugging me. Thanks
chergh blah Local time Today, 05:00 Joined Jun 15, 2004 Messages 1,414 Jan 23, 2008 #5 LB79 said: Its the form not the record... With DoCmd.Save acForm, form_name_as_string How would I type this if my form were called FORM1? Ive tried a few things and its debugging me. Thanks Click to expand... err... Code: docmd.save acform, "FORM1"
LB79 said: Its the form not the record... With DoCmd.Save acForm, form_name_as_string How would I type this if my form were called FORM1? Ive tried a few things and its debugging me. Thanks Click to expand... err... Code: docmd.save acform, "FORM1"
L LB79 Registered User. Local time Today, 05:00 Joined Oct 26, 2007 Messages 505 Jan 23, 2008 #6 Thanks - ive tried this and its works, but then when i close the form and open it again, the form reverts back to what it was before the save function. Do you know what Im doing wrong?
Thanks - ive tried this and its works, but then when i close the form and open it again, the form reverts back to what it was before the save function. Do you know what Im doing wrong?
