prompting for criteria before printing
Hii,
I have created a small check writing program which consists of a table name "DATA" with fields CHEQUENO, CHEQUEDT, BANKNAME & AMOUNT & also a query with date criteria with the above fields. I have 2 problems while generating reports
1. I have created a report based on the above query the problem is that while entering data into table i will enter all the fields except "CHEQUENO". The check should be prompted when checks to be printed & same time check no to be updated simultaneously in "DATA" table aganist the record.
2. "BANKNAME" consists of atleast 3 different banks for which a different series of check no is used, for which each time as an when bank name changes in a query report should prompt for starting check no & it should be incremented sequentially.
Any help on VBA coding for this.
Thank you.
|
