Combo Box

[Andrea]

I want to have a combo box with a list of numbers when you choose one of the numbers in the box it is not available to choose again.

For example, the box might have 1, 2, 3, 4, 5. Once I use the number 1, the only numbers that show in the combo box for the next record are 2, 3, 4, 5. Is this possible? Thanks

I think it is a relationship issue. I think I can make it a one to one and maybe that will do the trick.

 

[charityg]

Try creating an unmatched query between the table that will store the value from the combo and a table that will list the values. Then set that as the rowsource for your combobox.