Serialize

[Diana Avila]

Hi there;

I need my form to have a serial number in the "Cotización No." text box. The general idea is that every time the user fills the form and prints it the "Cotización No." changes its number in ascending level. Maybe the images will explain it better. The first one pretends that the user prints the form the first time The second one pretends that user opens the form a second time and so on.

 

[jdraw]

see if this helps.
http://www.techonthenet.com/access/modules/sequential_nbr3.php

 

[Diana Avila]

Hi I copied the MVBA code but once I need to this message pops up: "An error occurred while trying to determine the next sequential number to assign" what did i do wrong?

 

[jdraw]

Hi I copied the MVBA code but once I need to this message pops up: "An error occurred while trying to determine the next sequential number to assign" what did i do wrong?

There are additional instructions at the bottom of http://www.techonthenet.com/access/modules/sequential_nbr3.php
that describe/resolve that error.