Saving records in a form using a recordset on a cmd button.

[JeffBarker]

Oops, my error... You will have to embed the code I provided earlier within another IF..THEN. If the check box is checked, its value is -1, so we need to make sure it is checked prior to executing the code. If it is unchecked the value =0 and you don't want to do anything else I assume, so we do not need the ELSE portion of the clause.

If me.checkboxname=-1 Then

code provided earlier


End if

What style of form are you using (datasheet view, form view, continuous etc.)?

It's a single form with previous/next buttons to cycle through the records.

Thanks for the code...just putting that in now!!

 

[JeffBarker]

Hi there,

I've sorted out this problem:

a fax/email for the first record you did will appear, instead of one for whichever record you're currently on.

Turns out the print preview for the faxes will "stack", so using the previous/next buttons there will cycle through the available faxes to print!!

D'oh!

 

[jzwp22]

Glad to hear that you worked it out! Good luck with your project.