Then you should use a text field instead of an autonumber field and write code to automatically fill the field on the form's current event. Values could be stored in a "variables" table that are used to calculate the next unique key.
HTH, Toby ----- Original Message ----- From: "sboone1982" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, September 16, 2005 9:11 AM Subject: [AccessDevelopers] Auto Complete Sequence in Unique Field > Hello Everyone, > I'm trying to figure out if there is a way to autonumber a unique key > field but to have it autonumber in a specific order. The issue is > that we have inventory stickers that we mark on boxes but I need the > auto-complete or auto-number to match with the sticker. I also need > to be able to have the field editable in case we lose a roll of > stickers and have to start at a number that isn't part of the current > sequence. The field is alpha-numeric. > > Any thoughts or suggestions would help greatly! > Thanks! > SBoone > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
