FindRecord - Name Swapping Problem

[Guest]

Hello,

I'm having trouble using FindRecord in a bound Combo box. When i use it the
employee names get overwritten.

For examle, if "Sharon" is the current record and I select "James" from the
Combo box "James" becomes the current record, but the "Sharon" name is
changed to "James". So what I end up with is two different records that both
say "James".

I think this happens because the Combo is bound to the main table?

If this is correct how can I find records in a bound Combo without the side
effects of name swapping.

-Simon

 

[Rick B]

I combo box used to FIND a record should not be bound. You are correct.

Create a new "find" combo box and use the wizard to walk you through how to
set it up to find a record based on the selection.