Not in list. When it is

  • Thread starter Thread starter todatanet
  • Start date Start date
T

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
 
Unless you're mistyping something, my only guess would be a corrupted
control. Try deleting the combo box and making a new one.
 
Wayne said:
Unless you're mistyping something, my only guess would be a corrupted
Click to expand...
control. Try deleting the combo box and making a new one.
Click to expand...
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.
 
Back
Top