>I am using a Combobox with recordsource type set to fields. I set a filter on the table to show just the records I want. If there are more than one records shown everything works fine, but if there is only one record the =seek(this.value) in the Valid does not work. If I first look up customer that has several orders, select one from the combobox and then select a customer with only one order it will work OK. Why does this behave this way?
>
>Shane Gilbert

Above problem is also our question/problem. We do use SQL coupled with REQUERY rather than FIELDS or ALIAS if there is Filter condition, but if there is none, we use Fields or Alias. The only disadvantage in using SQL on combobox is that, you are not navigating the record on the disk, and so, you have to seek whatever the value returned upon selection.