Msgbox display data from table

S

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
 
A

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.....
 
V

Vlad C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
How to have two tables on same line? 1
Creating a Chart on form from selected data in query. 0
Append Crosstab Query to Existing Table 0
Help creating a search form in Access XP 0
VBA office 365 on windows 10 0
Remove Identical words 0
Making a macro only work on certain files 2

Top