changing drop down list in existing database

[AccessNovice]

One of the fields in my existing database has a drop down box with several
options, which are fed from a table. I would like to delete some of the
options, and replace them with new options, but I don't want these changes to
affect the data that I've already stored in my database, only the future data
that is entered. Is this possible?

 

[Wayne-I-M]

Hi

It should cause any prroblems providing that the new items in your combo
don't go against any fortmats in the field being saved to. As an example if
you are storing data in a number field (the bound column of your combo) and
you try to store data this will be a problem.

Anything you store will not affect previously stored records.

Open the form in design view and select the combo or list. Select the
properties box and in the data column select the Row Source and click the
build option (...) You can make a query that your combo will be based on.
Don't forget to alter the column widths if you need to.

Hope this helps

 

[Wayne-I-M]

Should read

It should "Not" cause any prroblems providing that the new items in your
combo
don't go against any formats in the field being saved to. As an example if
you are storing data in a number field (such as the bound column of your
combo) and you try to store "Text" data this will be a problem.

Sorry typos