changing drop down list in existing database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AccessNovice - 31 May 2007 21:51 GMT

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?

Reply to this Message

Wayne-I-M - 31 May 2007 22:07 GMT

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

Signature

Wayne
Manchester, England.

> 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?

Reply to this Message

Wayne-I-M - 31 May 2007 22:12 GMT

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

Signature

Wayne
Manchester, England.

Reply to this Message