Greeting!

I'm a newbie to access, actually, I simply fumble with it, trying to make better tools in my work place. So far, I'm able to create new tables and forms but there is a lot I don't understand so anyone answering to me must be patient! :(

Here is my question: my boss wants to have a manual form that will be numbered automatically and that will increase by 1 for every copy that is printed. Also, the next number we are at need to be saved do that we can continue printing the next forms starting at that number when we reopen the file.

So far, I created a form in publisher and I imported the .gif in Access, but I'm stomped because I have no idea where to start. BTW, I have no knowledge of VBASIC...

Thanks for any help you can give me!

Thoram,

For info on creating your own numbering scheme, use the Search Facility here and
look for DMax. You'll find a lot of posts on that. Your alternative is to use
the AutoNumber, but it might have gaps (you'll see that discussed when you search).

For info on forms in general, look at the sample database section here. Also look
at MS samples like NorthWind, etc.

Wayne