Form needs to be auto-populated with next sequential number

[stanley721]

I'm about to throw in the towel, but it's eating at me. I made those corrections and the "TrackingNumber" on the form is not populating. I am going to try to send a screen capture video of things if that is possible.

[Missinglinq]

The code I gave you needs to be in the Form_BeforeUpdate event, not in the Text53_BeforeUpdate event!

My signature was chosen because it is very true:

The Devil's in the Details!

Linq ;0)>

[stanley721]

Yes, stupid mistakes and no attention to detail. I should have caught that. But now I get(see attachments), for Me.TrackingNumber = Format(Date, "YY") & "-001" in the beginning.

[Missinglinq]

That would indicate that either the Textbox holding TrackingNumber is spelled something other than TrackingNumber, in the code, or the Table name is something other than "Record List." Does the Textbox name have an Underline character between Tracking and Number

Tracking_Number

or a Space between the two:

Tracking Number

Last possibility would be a Missing Reference.

Linq ;0)>

[stanley721]

Don't know what it was because I checked everything. I went back to the code and re-wrote it and bam, it worked. I guess there is now way to get that tracking number to display prior to leaving that record add page? My people write the assigned tracking number on top of the filed hard copy. I know they can just look back one record, but it would be nice if it just showed up prior to leaving that record's page. But hey, I'm happy with that if it isn't possible. Thanks for the help, and now you can get back to your own work!

[Missinglinq]

How about if you had a MessageBox pop up just prior to moving to another Record or closing the Form? that displayed the last ID Number?

In the Form_BeforeUpdate event, after all other code (i.e. just prior to the Sub End line) enter this code

Msgbox "Last Tracking Number was: " & Me.TrackingNumber

Linq ;0)>

[stanley721]

Awesome. Thanks!

[Missinglinq]

Glad you got it working!

Linq ;0)>