Repeating Data

[Guest]

I have created my table. What I would like the table to do is show previous
words that are the same in a field to appear. For instance if I type in Iron
in the ingredient field and then I type Iron again but down several rows I
would like the word Iron to appear so I do not have to type it again, just
click on it. I do not want to create a combo box because there will be
several words and new words added.
Thank you

 

[James Hahn]

You won't do this in a table - you'll need a form. But you'll have to
explain how you want this to work. For instance, exactly how are you going
to indicate that "Iron" should now re-appear at a particular point in the
process?

A combo box does seems the right way to do it. The fact that there will be
several words and you will be adding new words doesn't matter.

 

[Larry Daugherty]

Hi Gaayle,

You should not be entering data directly into tables. You should use a Form
instead.

There is no better way to get done what you want done than by using a
combobox with Autoexpand True and LimitToList True and basing it on a table
used for lookup. Limiting it to the list prevents a user entering new data
when it's really just a typo. By using LimitToList you can bring up a
message box telling them that what they just entered is not in the list and
then allow them to add it if they wish.

HTH