**sneaks in to avoid being stonned to death for asking yet another question**

Ok, what I am trying to accomplish is this: the file library forms I am making right now are working beautifuly, as long as you dont make any errors as I have no trapping atm, but thats beside the point. One of the forms, frmLibrary_New_Book brings up automatically the name and number of the project the new book belongs to, and it has a drop down box to select the "name" of the file its self.

Here is my proble, I need the next book number to come up as well. While I can generate the number in a querry, I am having no end of problems getting that number from that querry in VBA. Can anyone tell me how to either A. get that bit of info from that query, or B. loop through a recordset, count the number of times a project number comes up, and store the result +1 in a variable?

Thanks to anyone who gives any thought to this.

Brandon
-=it's not your fault you don't understand...your just stupid is all=-