Ensure the form I'm on is last record

[zippy483]

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?

[hertfordkc]

I've used two ways and not been happy with either. However, I'll suggest that when you enter a new receipt or a new removal, the "afterupdate" event runs a query that determines the new balance and stores it somewhere. I've tried running the sum over all transactions and assuming the beginning inventory is zero, but that leaves me feeling like I've cheated or been cheated.
For a professional answer, I believe the Northwind database example has an inventory example.
In other words, looking for the "last" record is an Excel mindset. However, assuming your delivery and withdrawal records have a date, you could run a query and find the last date on those records, pick the last inventory off the "last" record, update it and store the new inventory in the new record.