-
SOLVED THE PROBLEM: IN THE TABLE -ORDERENTRY- I CHANGED THE AUTONUMBER TO A TEXT BOX.
THEN IN THE FORM I ADDED =DMax("JOBID","ORDERENTRY")+1 TO THE DEFAULT VALUE UNDER DATA. WHAT THIS DID: IT ALLOWED THE AUTONUMBERING TO CONTINUE FROM THE LAST NUMBER I ENTERED AND ALSO ALLOWS THE NUMBER TO BE EDITABLE.
NOTE: IF YOU ADD A LETTER AFTER THE NUMBER WHEN THE NEXT RECORD COMES UP IT WILL SHOW ERROR IN THE NUMBER FIELD. ALL YOU HAVE TO DO IS TYPE IN THE NEXT NUMBER AND IT WILL CONTINUE NUMBERING FROM THAT INPUT.
GARY
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules