Exclude previous selected records

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

Guest

If records has been selected, I would like it to be excluded from the
dropdown combo box in the form. The reason for this so that the list can be
shorter.
I am thinking of putting a yes/no field in the table. If a record selected
from the form, then somehow (VBA) it put a yes in the yes/no field.
Can someone help me with VBA for something like this?
Thanks
 
Ashley

How do you currently "know" a record's been selected? I ask because you may
already have a mechanism for limiting the row source for your combo box.
For example, if, as part of whatever process you are using to "select" a
record, you also update a date/time field (MostRecentUpdate), you could use
that as a criterion for excluding records.

Are you saying that once selected, a record should NEVER again be listed in
your combo box? What if a particular record was selected in error? How do
you ensure that you can "unselect" it?
 
Back
Top