Sam Summers
Registered User.
- Local time
- Today, 03:40
- Joined
- Sep 17, 2001
- Messages
- 939
Hi again,
I have tried literally hundreds of ways and searched but just cannot get this to work?
I have an unbound textbox "PO_Number" with this as its control source =[Prefix] & [OrderedByInitial] & [POYear] & [PO]
This is to produce a unique PO Number that looks like this PO-T02110036
[Prefix] = PO-
[OrderedByInitial] = T (but this is dynamic depending on who the person ordering it is)
[POYear] = 021
[PO] = 10036 (which is an autonumber)
I am trying to insert the entire number (PO-T02110036) into the current records PONumber field which i also have on the form to see that it is working but so far no luck.
Many thanks in advance if you can point me in the right direction
I have tried literally hundreds of ways and searched but just cannot get this to work?
I have an unbound textbox "PO_Number" with this as its control source =[Prefix] & [OrderedByInitial] & [POYear] & [PO]
This is to produce a unique PO Number that looks like this PO-T02110036
[Prefix] = PO-
[OrderedByInitial] = T (but this is dynamic depending on who the person ordering it is)
[POYear] = 021
[PO] = 10036 (which is an autonumber)
I am trying to insert the entire number (PO-T02110036) into the current records PONumber field which i also have on the form to see that it is working but so far no luck.
Many thanks in advance if you can point me in the right direction