List Box that shows previously entered items

[Guest]

I created a very basic MS Access database in version 2002. I started by
creating the table in "Design View". Most of the items are basic text fields.
Once done, I saved it and then turned it into a form by using the wizard in
"Forms". I'm very happy with the database form that I created and it looks
and work well. Since some of the fields will contain the same item (data)
from the previous record it seems that I should be able to use a list box of
some kind to show the previously entered information for that field. This way
I can choose the item for that field and move on to the next field without
having to type the item in the field. This would same me a lot of time and
would allow me to make a choice of item as some fields will change items or
at least have a choice of 1 or 6 items.

Thanks for any help.
Jeff

 

[Al Camp]

Jeff.

If you more than 8 or so possible choices for the field, use a combo, if
not, a list box. I prefer combos, because they take up less real estate on
the screen.
For example, a field called CarModel...
In the query behind the list box, use just the CarModel field form the
table itself. Make it a Totals query with grouping on CarModel (so you
won't show dupes), and perhaps add a criteria of IsNotNull to avoid a choice
of "blank".
This will list just those CarModels that you've already used in the past,
and if LimitToList=No you can add a new model when needed, and then
thereafter, all subsequent records will have that choice available too.
hth
Al Camp