The text box I am trying to populate is Text box 2 (I found this on the selection pane) I have just tried to change the Field source for the text by first changing the number to '3' after the text 'JHA #" with no luck, I then removed the text altogether and changed the number to '1' & '0' with no luck either. I'm not sure if you can tell, but I am totally new to this and have just been butchering my way through this trying to work out how they work. Appreciate the help Macro.