Save form

[pm4698]

Hello there!

I have created a form and i have put one button to print the form after selecting some values through combo boxes.

After that, i have put a button that clears all the values so i can reuse the form.

How could i save a form?For example, for today, i complete the form and before i clear the fields i want to save it to a backup file. (Word or anything)

How could i do this and what do you suggest?

Thanks in advance

 

[Poppa Smurf]

Are you using an unbound form/ If so, when you click on the Save button you could use some code to write the fields to a table.

 

[pm4698]

is there a way to click a button and the a report is created?
The report could be like a mirror to the form and then i could save the report perhaps?

 

[pm4698]

ok i found this and its working fo me!

Private Sub ΑΠΟΘΗΚΕΥΣΗ_Click()
On Error GoTo Err_button_name_Click

DoCmd.OutputTo acForm, "form_name", acFormatPDF

Exit_button_name_Click:
Exit Sub

Err_button_name_Click:
MsgBox Err.Description
Resume Exit_button_name_Click
End Sub

it also works for reports too.
Instead of acForm you type acReport.

Thank you for your time