Email current record - Form

[SteveAccess]

Hi all,

I would like to use a check box that when ticked emails the current record in a form to a specific address that relates to a specific field in another table. I am very new to this and have no experience in VB. Any help greatly appreciated.

Cheers

Steve

 

[John Big Booty]

Rather than emailing the current form. You would be better off emailing a report that replicates the look of your form. You can use the following criteria in a query to populate the report with the data relevant to the current form;

[Forms]![YourFormName]![YourRecordID]

 

[John Big Booty]

Given that you are using Access '03, the best format is probably the Snap Shot format, for which, your recipient may need to download the free Snap Shot viewer available here.

 

[SteveAccess]

Thanks John, when I create the query with [Forms]![YourFormName]![YourRecordID] in the ID field and have a report running from it I keep getting prompted "Enter Parameter Value"

 

[John Big Booty]

You need to have the form open on a record. If the form is not open then you will get a prompt to enter a parameter.

You could put a button on your form to send a report, using the SendObject method.

 

[SteveAccess]

Thanks John, have just found that if I close the form then reopen it the job works fine, how can i get it to refresh the form so I dont have to close/open all the time?

 

[John Big Booty]

If you are trying to send the report on a record that you have just created, try putting the following code as the first line in your event code;

Me.Dirty = False

This line will effectively save changes to the current record.