Getting a Box # of # to work in form

[snydyman]

First I'll break down this database. Its about 4000 project numbers, some repeat, some do not. Due to these numbers that repeat I need a box that displays which "box number" I am on within these repeat project numbers. Example there are 3 project number 010054's and the box counter will display box 1 of 3, box 2 of 3, box 3 of 3 as you click through them via the next or previous button. My issue is I can not get this counter to work correctly. I have it working through a different query than the form is linked to, however when I try to add new information, it does not allow me. I am not familiar at all with VB so I was wondering if there was an easier way to do this with VB. Any information regarding this issue would be much appriciated.

[Rabbit]

Why do you have duplicate data? How do you tell one unique record from another if you have no unique identifier? You need to be able to identify a unique record if you want to get that working correctly.

Also, please show us the code you tried. It's hard to tell you what's wrong with it if we can't see it.

[snydyman]

We solved the issue, used the code

=DLookUp("RowCounter", "qryBoxNum", "[ID]=Forms![Archives]![ID]")

to produce the number we are currently on and

=DLookUp("CountProject","qryTotalBoxList","[ID]=Forms![Archives]![ID]")

to produce the amount of repeats.