Hello Nadya,
I fixed everything and made it work just the way I want it. But now I can't use a view with parameter(which I was using), it has to be simple lookup view. The conditions is: user enters partial account number, hits F4 or clicks DropDown arrow, the list opens up and the first highlighted record is the first from the group of records that begins from that partial account number. I did that with LOCATE statement.
The only problem that the first record from the group of records that begins from the partial account number entered by user, is NOT the first record in the DropDown list. Another words, if the user entered 11 as a partial account number, the first records in the DropDown list are the records that begin from 10(let say there 5 of them) and the record #6 is the first record that begins from 11.
Now, is the any way to make record that begins from 11 to be first (and the rest of the group followed it)in the DropDown list? I mean, it can be records in the list before the target and after, I don't care but the one I need and the rest of them should be the first. The combobox RowSource Type is 6-fields, I guess I could change it to 3-SQL Statement (never used it, though) if this is will help.
If all this makes any sense, you think you might have a solution or advise?
Thank you very much, Nadya, for your help and time.
Igor