Displaying a field amidst text in a message box

[wrweaver]

I'm trying to display a field from a form in a message box. Is something out of order here?

MsgBox ("Your Work Order has been submitted. Your WO# is "& WorkOrderID.text" Please use the Work Order List to view the status of your Work Order. We appreciate your patience."), vbInformation

Thank you in advance!

 

[boblarson]

MsgBox ("Your Work Order has been submitted. Your WO# is " & Me.WorkOrderID & " Please use the Work Order List to view the status of your Work Order. We appreciate your patience."), vbInformation

Don't use .Text as that makes it so the control needs the focus. Use the default .Value instead (which means you can do as I show and not include it). The ME part just makes sure Access knows that it is the object on the current form.

 

[wrweaver]

Perfect. Thanks!