Hi All
Bit of newb to all this programming, and I'm working with a dB someone else has designed that has landed on my lap.
Part of the database has a stock control section that at the moment is fairly rudimentary
I'd like to allow stock to be automatically incremented and decremented when numbers are written either into a parts used form or a parts ordered form. To do this I need to know that the form I'm on is the last record in the dataset and only allow the code I've written to run if the form is the last record. all the forms have an autonumber field.
How do I determine that the form I'm on is the last form in the dataset from the autonumber field?