matthewnsarah07
Registered User.
- Local time
- Yesterday, 19:29
- Joined
- Feb 19, 2008
- Messages
- 192
I currently have a Form 'frmLeaveRequest' which staff fill in and submit using a SendObject Function.
They select their name on the form from a table 'tblStaff' which contains they name as Surname, Firstname and their email address.
The Staff appears as Surname,Firtname on the form but the combobox is bound to the email address in order for the SendObject to gain a valid email address.
However when the form is exported as a snapshot report the email address appears as the Staff Name - where I would like their name to appear as Surname, Firstname.
How would I go about reformatting the name in the report prior to sending or can it be done within the form itself?
They select their name on the form from a table 'tblStaff' which contains they name as Surname, Firstname and their email address.
The Staff appears as Surname,Firtname on the form but the combobox is bound to the email address in order for the SendObject to gain a valid email address.
However when the form is exported as a snapshot report the email address appears as the Staff Name - where I would like their name to appear as Surname, Firstname.
How would I go about reformatting the name in the report prior to sending or can it be done within the form itself?
