Records changing on tab out of combo box

[Guest]

I have a combo box that displays the primary key of my table. I want the
user to either be able to type in the key and display that record or select
the key from the drop down box. This works fine, except when I tab out of
the combo box, the record changes but leaves the original key in the combo
box. Any ideas would be great. Thanks. Matt

 

[Allen Browne]

You are trying to do 2 different things with one control. Provide a one
combo box to navigate record (an unbound one) as well as the one that
actually enters a value (the bound one).

There is a wizard to create the nav. combo for you, or you can use the code
in this link:
http://members.iinet.net.au/~allenbrowne/ser-03.html

 

[Guest]

I'm not wanting the user to be able to add new records. I want them to be
able to type in the key that they are looking for instead of having to scroll
through the list in the drop down box. I want them to be able to do this in
the navigational combo box. This works fine right now, except when I tab out
of the key field, the record changes. I'm not sure why the record changes as
soon as I tab out of the field. Any ideas would be great.

 

[Allen Browne]

Sorry: I don't follow. You want to use the combo to find another record and
display it in the form, but you do not want the form to move to that record
when the user chooses something in the combo???

It is probably code in the AfterUpdate property of the combo that causes the
form to move record. Remove the code if you don't want that to happen.