I have a form with a autonumber field named [WorkOrderID].
I have a button that when clicked generates a report based on the form then auto emails it with the title "New Work Order".
I am trying to get the title to concatenate the "New Work Order" with the current [WorkOrderID] and put them together.
e.g New Work Order #193
the 193 is from the [WorkOrderID] Field and "New Work Order #" Is just text put in the VBA code.
Thanks,
I have a button that when clicked generates a report based on the form then auto emails it with the title "New Work Order".
I am trying to get the title to concatenate the "New Work Order" with the current [WorkOrderID] and put them together.
e.g New Work Order #193
the 193 is from the [WorkOrderID] Field and "New Work Order #" Is just text put in the VBA code.
Thanks,