Hello!

i need some urgent help.

i need to create a pop-up text box that requires me to display the data of a certain field.

for example, i have a form that allows me to update these particulars:

- name
- address

and after manually typing in the details, i would have to click on a command button that creates this pop-up msgbox that displays "hello, (name)! you live at (address)."

i've applied the macro msgbox function. however i was stuck for a long time at the message part! how can i put name and address field into the actual pop-up box??


thank you very very much!

I don't think this will work in a macro although you could probably do it with vba. But if you must use a maco, why don't you create a form that looks how you want that will pull the info from you open form, and set the command button to open that form, then you can avoid a macro altogether.