P
peli45
I have a problem with the display of previously selected values in a ListBox.
Hopefully the problem is of general interest and will get you interested.
The Microsoft Access 2003 database has 4 tables with corresponding forms:
- States, has 3 records, Draft, Active and Passive and is regarded as a
system table.
- Categories, here you can enter any Category you like, and also set the
State of each Category.
- Items, here you can enter any Item you like, and you must select a
Category with State = Active.
- Picked Items, is lika a Shopping basket, you can pick any Item with State
= Active.
Problem:
If I change Category State from Active to Draft or Passive, the Category
does not display in the Items form. It is displayed in the PickedItem form,
but there it is no SELECT statement containing WHERE
(((tblCategories.StateID)=2)).
If I set the State of an Item to Draft or Passive, the Item does not display
in the Picked Items form, but the Item's Category is displayed.
Desired functionality:
I want the non-Active Category to be displayed in the Items form even if it
not selectable. If I want to change Category, then I can only select from
Active Categories.
Hopefully the problem is of general interest and will get you interested.
The Microsoft Access 2003 database has 4 tables with corresponding forms:
- States, has 3 records, Draft, Active and Passive and is regarded as a
system table.
- Categories, here you can enter any Category you like, and also set the
State of each Category.
- Items, here you can enter any Item you like, and you must select a
Category with State = Active.
- Picked Items, is lika a Shopping basket, you can pick any Item with State
= Active.
Problem:
If I change Category State from Active to Draft or Passive, the Category
does not display in the Items form. It is displayed in the PickedItem form,
but there it is no SELECT statement containing WHERE
(((tblCategories.StateID)=2)).
If I set the State of an Item to Draft or Passive, the Item does not display
in the Picked Items form, but the Item's Category is displayed.
Desired functionality:
I want the non-Active Category to be displayed in the Items form even if it
not selectable. If I want to change Category, then I can only select from
Active Categories.