A
Ashley
I have a list of pre-assigned serial numbers in a table. User must select a
number from the list in the combo box. Once the number used/selected, it
should not use again. I would like the used/selected numbers not to be
displayed in the combo box. Does anyone know a good way to do this?
I am thinking of putting a yes/no field in the table, default is "no". If a
record selected from the form combo box, then somehow (VBA) it put a yes in
the yes/no field. Then I can use a criteria in the combo box to show only
records with "no". But I am stuck on how to make it put a "yes" for
used/selected records.
Can someone help me with VBA for something like this?
Thanks
number from the list in the combo box. Once the number used/selected, it
should not use again. I would like the used/selected numbers not to be
displayed in the combo box. Does anyone know a good way to do this?
I am thinking of putting a yes/no field in the table, default is "no". If a
record selected from the form combo box, then somehow (VBA) it put a yes in
the yes/no field. Then I can use a criteria in the combo box to show only
records with "no". But I am stuck on how to make it put a "yes" for
used/selected records.
Can someone help me with VBA for something like this?
Thanks