Insert name of the caption into the message box

  • Thread starter samotek via AccessMonster.com
  • Start date
S

samotek via AccessMonster.com

How could I parse the name of the caption to the message box ? For example,
if the caption of the control is Paris, I would like to insert the caption in
the message box and the message there to read “There are problems with the
warehouse in Parisâ€

Me!Command7.Caption = "Paris"
MsgBox "There are problems with the warehouse in …… !", vbOKOnly, "Warning"
 
K

Klatuu

MsgBox "There are problems with the warehouse in " & Me.Command7.Caption,
vbExclamation + vbOKOnly, "Warning"

Those darn French are always up to no good <g>
 
Top