Repeat selection in Combobox

[Dodgy Dave]

I currently have a form which allows users to select a
Store Number via a combobox, and enter the number for the
relevant shelving plan. The results are then dropped
neatly into a new row in the Store/Plan table.

The problem is, when you then hit the New Record button,
the combobox reverts to a blank, and you have to select
the store number again. Since we have several shelving
plan in any one store, I'd like to get the combobox to
retain the last Store Number, until the user changes it to
another one. Is there a way to get a combobox to do this?

Thanks for any help.

Dave

 

[Jeff Rush]

This is Klugy but may work for you.

Have a Hidden Field on the form "ThisStoreNum" initialize it to "Empty" on
open.
Then on submit populate that field with the store num.On Refrese copy the
contents of "ThisStoreNum" to the appropriate field...

HTH,

Jeff