Drop down menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
Click to expand...

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]
 
Thank You

Yanick said:
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.
Click to expand...
 
Thank You John, I'll try that

John Vinson said:
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]
Click to expand...
 
Back
Top