ComboBox Selections

  • Thread starter Thread starter bk
  • Start date Start date
B

bk

I'm selecting items from a combo box to populate a subform
for a customer - everytime he makes a entry,he doesn't
want the combo box selections to show the items previously
selected . If I filter out - the previous selections
disappear as well. is it possible to filter out the combo
box selections already selected and still display after
selected.
 
Bk,

I don't think it is possible as stated. However, there are a couple
of ways that I have handled this type of situation, depending on
circumstances...
1. Cover the data box section of the combobox with a textbox, with
its Locked property set to Yes, and possibly Enabled to No, and bound
to the same field as the combobox. When you click on the drop-down
arrow on the combobox, it brings the focus to the combobox, which then
appears in front of the textbox for the purposes of data entry.
2. Make a query to return rowsource records not already selected via
the combobox. Make another query to return all those which *have*
already been selected. Join these two queries together using a Union
Query, inserting a row of ----------- between them. That way, you can
get the "available for selection" values showing at the top of the
list, and the unavailable ones still included in the rowsource, but
stashed away at the end of the list.

- Steve Schapel, Microsoft Access MVP
 
Back
Top