Not in list. When it is

[todatanet]

Hi Everyone

I have created a vehicle serviceing database in access 2000. Which
tracks 97 vehicles as and when they become due for service, and or
equipment inspections.

Using a combo box to type in the registration number and call up the
vehicles details works fine some of the time. What happens is. Type in
a Reg Number and it says "not in list". When it is! I then scroll down
the list of reg numbers and its there. click on the reg number I need
and it opens the record no problem. Is there somthing like a requery or
can any one point me in the right direction to correct the problem.
Any Ideas most appreciated

Thanks
Mike

 

[Wayne Morgan]

Unless you're mistyping something, my only guess would be a corrupted
control. Try deleting the combo box and making a new one.

 

[todatanet]

Unless you're mistyping something, my only guess would be a corrupted

control. Try deleting the combo box and making a new one.

Thanks for that Wayne, strange thing is the reg number typed in,
appears exactly the same as the one in the list that access cant find.

I will try making a new combo box see if that works.