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
Elyse Pomerantz