VBA is rusty need to lookup last line of a table for ref. in form

[badbane]

I am using a form to update information in my database.

I have three tables. The database references which dvd's user profiles are backed up on. Since some backups go across multiple disks I have a series number along with a disk reference number. So if a user backup takes more than one disk I simply keep counting up in my disk reference and stop counting for my series number.

Also if there is more than one user on a disk then I can stop counting up on the disk reference but continue to count up on my series number.

The easiest way to make sure I can update the databases without issue is to have two text boxes on the form that, when I open the form, reference the last Series# in my series table, and the last name and first name from my employees table where i use employee number to reference the employee table.

Then after I input the new record via the form the textboxes would update with the new information?

I am familiar with Vb.net but VBA in access is throwing off my mojo.

[NeoPa]

Is there a question in here somewhere (Rhetorical - there seems to be none.)? We don't deal with simple job specs.

If you have a specific question to ask on this then please go ahead.

[zmbd]

Thnxs Neopa,
Read thru this like six times, finally added the whitespace to the the post and still didn't find the question.

@badbane
What I don't get is why not have a single table with the customer information.
Then in the second table you have a simple entry that has the disk id and the customer id.
One entry for each disk with each customer on that disk?
Then the query would be simple... want all of the disks with a given customer, then, query on the customer id.
Add a date to this record and then one can filter down by date and customer...
Same idea by searching on the disk id, in that such would return the customers on that disk.
Only need is to increment the disk id as each new disk is used.
With what you describe, you can use an agregate query to return the maximums of the fields; however, these can have a few hickups to fix before the correct data is returned.
Would help to have: Tables, fields(datatype), relationship (if any) to other table(s).