>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?