display field value in msgbox as well as text

[AccessDevJunior]

hya,

when a user clicks 'save' i would like a msg box to appear displaying " 'Reference Number' has been updated' ".
'Reference Number' being the name of a field.

it would be a great help if someone could show me how to o this

 

[RickSpr]

In your form module:
MsgBox Me![Reference Number] & " has been updated"

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[AccessDevJunior]

thanks exactly what i wanted, i thought it would have been something simple.

cheers