Listbox with data entry problem

[daze]

I have form that is set to DATA ENTRY on (name of a customer) and list box of shelves names based on a table and this is what happens:

When a shelf is selected and customer is entered (trough combo box) the value of shelf is set to default (none selected).


So I'd like to have shelf name in list box stayed selected all the time until user decides to select different one.


Reason: there are often more than one customers name to be entered into a specific shelf (I'm talking about packages on shelves)

Any clue?

 

[KenHigg]

What you need to do is store the shelf name value somewhere. One simple option is to have a combo box at the bottom of the form that is unbound where you select the default value and then have the bound shelf name control default to it. Does that make sense. There are several different ways to do this that I can think of...

 

[daze]

What you need to do is store the shelf name value somewhere. One simple option is to have a combo box at the bottom of the form that is unbound where you select the default value and then have the bound shelf name control default to it. Does that make sense. There are several different ways to do this that I can think of...

I've been struggling with this, but no luck...

This what you suggest works, but only when opening form and it does not change after.

I’m trying to have user enter data (customer’s names) in to certain shelf name so that after it can be retrieved.
But… often user has lot of different customers on same shelf so I’d like to prevent user from entering same shelf name each times new data is entered.

 

[smig]

I'm not realy sure I understand your needs.
you can't keep the shelf selected, as it loose the focus.
clicking again this list box will bring the focus back to it, but the new shelf you will clck on will be the new selected one.

if you want to save the last one you clicked on you need to copy the data from the list box into another place.
I like to use the registery (SaveSetting, GetSetting). I like it mostly because the data saved even if you close all forms.