ListBox Help

[Pucklvr001]

Hi,
I have created a list box in a form I am making. The list box shows the item and then I can input the quantity for that item. What I want that list box to do is this.

After I entered the quantity and add a new record, how can I make the list box automatically select the next record so the user doesn't have to select the item from the list box. I want to make it REAL simple for the user.


Any help would be appreciated.

Thank you!!

[orange]

Why did you pick a list box for this?
What exactly are you trying to accomplish?

Items and quantities -- is this a Customer, Order, Item type database?

[June7]

Why would you presume the user wants the next item and every item after that? What is the business process here? Is quantity data for the same items entered on a daily basis?

[Pucklvr001]

What other way would I accomplish this? The user that is using this has ZERO access knowledge and it needs to be as SIMPLE as can be. They are only putting in information from the forms that I have created. They are getting a shell and that is all..

Essentially what I would like is a form that shows each item and they can just enter the quantity for each one.. but how do I make that if I don't know that records that they put in?

[June7]

If user doesn't understand data entry, they are still living in the stone age. Everyone who has interacted with a computer understands selecting item from a dropdown list. It doesn't matter how friendly you try to make this, basic computer literacy (keyboard and mouse) and knowledge of your business process is mandatory.

You can have a form automatically open when user opens db. That form can present user with a set of records that were created by a code procedure. All they have to do is enter the quantity for each. But what if there is no quantity for one of the items? This leaves an unnecessary record in the table. Another procedure can deal with that and delete the record.

The more friendly, the more code.