Save button to produce document number

syedadnan

Access Lover
Local time
Today, 18:41
Joined
Mar 27, 2013
Messages
315
Regards,

I have a table "A" fields on a form, i want when i check the check box and hit save button it generate document number in this way; as all records are displaying at form just i have to select the item through check box and i want if i select 3 items from 5 listed in form through check box then the save button to produce number from 0 as default and then +1 after if i select the remaining item after first selection and save. for example;

ID Item Check box Doc number
1331 Telephone Yes 0
1331 Papers Yes
On selection first 2 items;

If hit save button here after selecting 2 items.. then the number should be +1 as default would be 0 for first record based on ID

ID Item Check box Doc number
1331 Calculator Yes 1
1331 Pen Yes
1331 cup Yes
On selection other 3 items;

If hit save button here after selecting some more items.. then the number should be +1 as with reference to the previously issued number based on ID

ID Item Check box Doc number
1331 Ribbon Yes 3
On selection other 1 items;
 

Users who are viewing this thread

Back
Top Bottom