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

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.

Bob, you've done it again!

Many Thanks

Glad to be of assistance :)