Running Query that will return next highest number in table on form

[banpreet]

I went with Johns way of doing the nz function and it works. Did not do your way, just need a way to get the format of TR- in the beginning doing it Johns way. Thanks