Msgbox display data from table

[Shane]

How do I get a message box to display data from a field
in my table. For instance:

msgbox "I have [field] dollars in my account"

Thanks

 

[Allen Browne]

Use DLookup().

Details:
http://allenbrowne.com/casu-07.html

 

[Dave Jones]

msgbox "I have " & [field] & " dollars in my account"

Dave

 

[Al Campagna]

Shane,
I take it that [field] contains the value you want in the MsgBox

Use "Concatenation" in your MsgBox Prompt...

MsgBox "I have " & [field] & " dollars in my account.", ......etc.....

 

[Guest]

Shane,
Just write msgbox "I have " & Form.Controls("YourField") & " in my account".

----- Shane wrote: -----

How do I get a message box to display data from a field
in my table. For instance:

msgbox "I have [field] dollars in my account"

Thanks