Ok, I received a response for my last question, but I don't think that I was explicit enough, so let me try again. I have a form that submits information to an E-Mail. The control source of my form is a select query(Calculation2), which populates a table(Adjustment Correction Form). What I have, is when a new record is created, it increases the record #(it's in AutoNumber format), and when you hit the submit button, it sends an e-mail out. In the body of that email, I want to put the current record number into it. What I have now is...
NotesDoc.Body = "A new Adjustment was
submitted under Record #"
& MyRecs![Record #].Value
It keeps saying "Record #1", since it is the first record. How do I make that the current record???
I would also like to set two other fields in that record when the submit button is pushed. I want to set the [Date Submitted] field to the current date and the [Time Submitted] field to the current time. How would I refer to those fields as well???Thanks in advance.
Doug
[This message has been edited by D-Fresh (edited 06-08-2000).]
NotesDoc.Body = "A new Adjustment was
submitted under Record #"
& MyRecs![Record #].Value
It keeps saying "Record #1", since it is the first record. How do I make that the current record???
I would also like to set two other fields in that record when the submit button is pushed. I want to set the [Date Submitted] field to the current date and the [Time Submitted] field to the current time. How would I refer to those fields as well???Thanks in advance.
Doug
[This message has been edited by D-Fresh (edited 06-08-2000).]
