Sending Forms via emails

R

Ridnaway

I have a work order request form that needs to be sent from person to person
to be completed. I have a command button on the form with an event procedure
entitled "Send Work Order". How can I instruct the recipient how to retrieve
the proper record if I identify each record by using an autonumber?
 
R

Rick B

Not sure what you are asking.

Saying something like...


"Please complete Work Order Number 125666"

Should do the trick.
 
R

Ridnaway

Right now, the message in the email states "You have been sent a work order.
Please access the work orders database via the switchboard on your desktop.
Use the "Find Record" button at the bottom of the form and choose record
number ##.

My problem is that when I do this I get a message stating something akin to
"You cannot retrieve that record now." Any thoughts? By the way, I think by
now I surely must owe you a cold beverage.
 
R

Ridnaway

I created the email message myself using the macro action titled
"SendObject". Are you referring to the message that said I cannot access the
record or the message I created?
 
R

Rick B

No - I meant the vba code. I don't use macros at all, so I am not sure how
to proceeed. Let's see if anyone else jumps in with some ideas.
 
Top