Limit combobox view list

[Skip Bisconer]

I have an unbound combobox to select records for my form. When selected there are 2 fields that get up dated then another record is selected. Is it possible to eliminate the records that have been updated from the combobox list?

 

[pbaldy]

What signifies whether a record has been updated or not? Generally, the rowsource of the combo can look at that:

SELECT Blah
FROM TableName
WHERE Updated = False

 

[Skip Bisconer]

The row source is the table being updated and has both fields in the rowsource. Could I limit it in the Rowsource something like is null? Because if the field was updated it would have a value in it otherwise it would be empty.

 

[pbaldy]

Sure; then just requery the combo and it should drop records that have been updated.