Combo Box Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
AllYourSpam said:
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?
Click to expand...

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
 
Back
Top