By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,315 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,315 IT Pros & Developers. It's quick & easy.

automated fields in a receipt

P: 38
I have a receipt form (access 2003) where I write checks received (between 12 - 36 checks for each client).

My question is : how do I automate check numbers (it's a running number by order), same bank (all checks are from 1 bank : how do I make each line in the receipt writing the same bank automatically) etc'.

I placed the following in the default value properties: "DMax "CheckNumberFieldHere", "tableNameHere")+1"
and it's ok but when I go to the next row, the check number goes 0 but there's another row with the following needed number (it actually creates 2 new rows : 1 =0 and the 2nd=the needed number). The following desired number skips a line.

Can you please figure this one out?

Jul 6 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.