Jeff,

Thanks for the info, yes I did you a format for the
display of my Autonumber: for tbleStockOrders I used the
format "NW-"0000, and for tblCustomOrders I used the
format "KI-"0000, I am using an update query to send the
info from the unionquery to a tblMasterInventory. Any
suggestions on how I can pull these formats into my
tblMasterInventory?

Thanks for your help!

Brook

-----Original Message-----
Brook

From your description, it sounds like you've used a
format to modify the
display of your autonumber fields. This doesn't modify
the data stored,
just the display of it.

--
Good luck

Jeff Boyce
Access MVP

.