Drop down menu

[Guest]

I designed a Db in Access 2002. One of my data entry forms has a combo box
field. The combo box gets it's information from a two column table
containing ID numbers in the first column and names in the second column.
The names appear in the drop down menu and on the form and the ID numbers go
in the table. Is it possible to make a name not show up in the menu but keep
it in the linked table so the name still shows up in old records but can't
be selected in new ones? Thanks

 

[Guest]

A simple way to do it will be by adding a field in your table specifying if
the name is valid for new record. Then modify your combo box queries to show
only the right name.

 

[John Vinson]

I designed a Db in Access 2002. One of my data entry forms has a combo box
field. The combo box gets it's information from a two column table
containing ID numbers in the first column and names in the second column.
The names appear in the drop down menu and on the form and the ID numbers go
in the table. Is it possible to make a name not show up in the menu but keep
it in the linked table so the name still shows up in old records but can't
be selected in new ones? Thanks

One way to do this is to add a yes/no field Active, default value
True, in the names table. Base your Combo Box on a query selecting
only active names.

John W. Vinson[MVP]

 

[Guest]

Thank You

A simple way to do it will be by adding a field in your table specifying if
the name is valid for new record. Then modify your combo box queries to show
only the right name.

 

[Guest]

Thank You John, I'll try that

One way to do this is to add a yes/no field Active, default value
True, in the names table. Base your Combo Box on a query selecting
only active names.

John W. Vinson[MVP]