Placing Table info into a msgbox

[donbettis]

Is it possible to pull info from a table into a msgbox...

I have a msgbox informing them that the record has already been added...I would like to tell them by whom and on what date...

I have two fields I'd like to pull into the message... CreatedBy & EntryDate

I'd like my msgbox to be something like this...

MsgBox("The Contact you are trying to enter was entered on "EntryDate" By "CreatedBy", vbOKOnly, "Contact is Already in the Database!")

Is this possible?

Thx

Don

Edited because of typo...

[This message has been edited by donbettis (edited 12-28-2001).]

 

[David R]

Try this topic: http://www.access-programmers.co.uk/ubb/Forum7/HTML/002007.html

HTH,
David R

 

[donbettis]

David R

Thanks...

I had to play with the code but I was able to get it to do what I needed...