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

fill data series in MS Access 2010

P: 1

I have a continues form, which contains Items, for example my items are like this: B-1,B-2,B-3....etc, i want when i entered B-1 in the first row, automatically write input B-2, B-3 in the second and third row, so i don't need to enter the items again and again.

I hope someone help me how to do this in ms access.

i don't want to use auto number, because for each customer i have different items, some start with A, some other with B anc C
Jan 23 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
Sequential numbering has been covered many, many times here at Bytes.Com (a few such threads follow).
However, to help provide something specfic for your situation, we'll need a little more information such as:

What version of Access are you using?

How are you entering the data?

Does the squence need to start over and if so under what criteria?

The more detail you provide the better.

The basic method is to create a query that uses the dmax() to return the highest number last used and add one.

This is just a few of the threads covering various aspects of the "serial/sequential numbering" topic:
[*This last one is jut a simple Google against the site]

ADezii has some very good code dealing with this too that a search here on his name will turn up
Jan 23 '14 #2

Post your reply

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