Report Snapshot from Form

[matthewnsarah07]

I am currently using a database to collect staff holiday forms.

When the form is complete the employee clicks the submit button which triggers a SendObject code, which sends a report called Leave Form.

The report populates from a query based on the current reocrd number showing on that persons request form at the time of submission, but sometimes when I send the report out it goes blank although there should be a reocrd.

Is there a quick way to remedy this, is it as simple as saving the record prior to triggering the send function?

All help appreciated

 

[boblarson]

Sounds like you do need to include this in the click event of your button:

If Me.Dirty Then Me.Dirty = False


that way the record gets saved prior to sending.

 

[matthewnsarah07]

Bob, you've done it again!

Many Thanks

 

[boblarson]

Glad to be of assistance