>>I have a ComboBox whose RowSource is an SQL. In the Valid event I do some
>>validation and in some case show a warning in a messagebox. In any case,
>>after the user selects a value (or types one in) I want the cursor to go to
>>the next field, so I 'RETURN 1' for a valid entry. This works fine if the
>>user types in an entry, but if they select from the list it seems to go
>>through the valid code twice, showing the same messagebox twice. This
>>seems to be caused by the 'RETURN 1' but if I leave that out the cursor
>>stays on that field. Any suggestions?
>>
>>Thanks
>>Elyse
>
>is the code in the valid or the lostfocus?
The code is in the valid.
Elyse Pomerantz