Combo Box Wizard

[Guest]

At a certain point the wizard asks - do you want to remember the value for
later use or store the value. What is the difference and when would you
remember vs store. Which is better?
If you choose store, does that put the data in the field, as opposed to the
key ID?

 

[Arvin Meyer [MVP]]

At a certain point the wizard asks - do you want to remember the value for
later use or store the value. What is the difference and when would you
remember vs store. Which is better?
If you choose store, does that put the data in the field, as opposed to
the
key ID?

Data that is stored is stored in the field, whereas later use refers to use
in code for unbound combos and listboxes. Always store the Key, never store
the data, and never use lookup fields in tables. Always use lookups in a
query instead:

http://www.mvps.org/access/lookupfields.htm