numbering continuous items in sub form (1 Viewer)

[kgcrowther]

I have a form with a subform. The subform is in continuous view so that multiple items can be viewed at a time. Each needs to have a number label starting with one and then counting up by ones.

More specifically, I am tracking software licenses. We own a lot of control software for which we only have a certain number of keys. I entered as the default value a 'DCount + 1' type of function which works great when you first open the form, but as you go to fill out the last of the continuous forms the next form comes down with the same number therefor not recalculating the default value.

Does anyone know (1) why doesn't it recalculate the default value again and (2) any ideas on how to fix this?

Kenneth

By the way: You guys are so smart!!!

 

[charityg]

I posted the answer for someone else. You can find it with this link.

The solution lies in using a custom function.
http://www.access-programmers.co.uk/ubb/Forum4/HTML/003597.html

You can also check out Microsoft's answer in the KB
http://support.microsoft.com/support/kb/articles/Q120/9/13.ASP?LN=EN-US&SD=gn&FR=0&qry=number%20records%20&rnk=19&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

Good luck! and let me know if you need more help!

Charity

 

[kgcrowther]

That worked great for the database that I was working on. I have another database that I want to actually store the numbers (instead of just display them) I tried just putting the function as the default value and it didn't work. It seems like this should. Do you have any ideas why it didn't!

Kenneth