Forms

[D-Fresh]

Ok, I have a big form where data is inputted. I have two basic questions here.

First is, I have an E-mail function attached to a submit button, that whenever you hit the button, it sends an E-Mail to a certain person. I have a field on the source table that has record #, and it is Autonumber. I have

Set MyDB = CurrentDB()
Set MyRecs = MyDB.OpenRecordset
("Adjustment Correction Table")

The field name in Adjustmen Correction Table is [Record #], how would I refer to the current record I'm working on as a variable.

The Second is this... I also have a check box, which sends a different E-mail if clicked. I have the function set to On Get Focus, which is what I assumed to be if the check box was clicked True. However, if I check it True, or Uncheck it false, it still sends the E-Mail. How could I get it to just send the E-Mail when I check the box true, not when it's unchecked false.

Thanks in Advance...

Doug

 

[ericgeil]

Maybe I'm misunderstanding the first one, but if the field is in the source table for our form, it seems you could just use
me.[Record #]

2nd:
I would use the After Update event to avoid firing an email if someone tabs to the control. Or, I would put it in your submit button, so the two emails are submitted only when the user decides. Also, in your code, to determine if the box is checked use:
If me.check1.value = -1 then 'if its checked
'code
'to send
'email
end if

Hope this answers your questions....

Eric

 

[D-Fresh]

Thanks a lot. That is exactly what I was looking for.

Doug