Joanne has attended:
Access VBA course
Is it possible to add an auto number to an unbound report?
Is it poosible to add an auto number to a report that is not bound to any thing because its document that can be printed off by the user. But I want the report to have a new number each time it is printed off is this possible.
Thanks
jo
RE: Is it possible to add an auto number to an unbound report?
Hi Joanne
Thanks for your question
An auto number is a data type, and therefore refers to a filed. As an unbound report has no fields behind it, the auto number cannot be used.
I suggest creating a table and storing the current report number as a long integer. I would the write code that runs when the report opens to increase the number by 1 and then update the number stored in the table
Regards
Stephen