Crosstab Query Help (Create a record number that restarts)

[bdhFS]

I think from now on in the data entry process I am going to try to assign a sequence number as the data is entered...that still does not solve this issue.

[June7]

So in the VBA editor under 'Modules' you created a code module and placed this procedure in it?

Sorry, I forgot al wrote the procedure with an argument. Could instead hard code the table name:

Public Sub AssignRowNum()

...

Set rst = CurrentDb.OpenRecordset("SELECT * FROM [tablename] WHERE Num Is Null ORDER BY ID, inkmark")

...

End Sub

al gave a suggestion for entering this value when record created in post 10.

[alcapps]

can you put the table of data in a clean database and upload it. I will put in the code and show you how to call it in a form or a module.

[alcapps]

codeTest.zipok..here is a form in a database calling the code. if you still have the dao issue let me know

[bdhFS]

SequenceNumberForInkMarks.zip

Not sure if I did this right

[alcapps]

Were you able to run the database I uploaded?

[alcapps]

SequenceNumberForInkMarks.zip

alright.. I think this should do it for you. I've given you examples of what you are trying to do. play around and this should answer your questions..

[bdhFS]

AWESOME!!! Thanks so much alcapps, I really appreciate your help.