Combo Box Unused Selection - Microsoft Access Forum


	Back to Access Forum Comments List

Combo Box Unused Selection

Kinikia Davis

4 years ago

I have a continuous form of employees and unit assignments for each employee. When I select assignment A for employee #1, I don't want assignment A to show as a combo box value when making a selection for employee #2. I tried to give the assignment an "IsUsed" field and removed all with "IsUsed" as a TRUE value from the combo box, but now I cannot see previously selected values in a continuous form. How to correct this?

	Adam Schwanz @Reply 4 years ago
You can't, it's doing what you told it to, taking that value out of the combo box, and in a continous form that means out of every combo box. What you could do instead is use DLookup to show the value in a text box.

	Adam Schwanz @Reply 4 years ago
You could also take the DLOOKUP textbox and move it up ontop of the combo box, position the combo box to the back, and it will have the appearance of being a combo box while still only listing the not used values in the combobox if you click the arrow

	Adam Schwanz @Reply 4 years ago

	Adam Schwanz @Reply 4 years ago
Also just throwing in you may need to use NZ Function or IIF Function to get it to display how you want it to when there is nothing selected in the combo yet.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen