Access Query for next record

Ok, here’s what I got.

I have a form used for Data Entry to add records to an Access DB. The table I am adding to has 2 primary keys, taskNumber and taskYear. Both are manually entered. What I am trying to do is when the user presses the Add button, and there is an error saying you cannot go to that record, I want to query the DB and find the next available taskNumber.

Can this be done????