Combo box record search problems

[uofte]

Thanks in advance for helping a newbie.

Basic setup - tblMain contains these items:
- Location Code (4 digits)
- Location Name
- Some variables like Miles Driven, # of employees, etc.

I did a form on this table. I inserted a combo box to select a record on the form using Location Code. It works great....until I try to tab out of the combo to one of the variables. When I tab, it moves to the next location name, i.e., the next record.

This problem is driving me bonkers. Can anyone help?

Thanks!
Dustin

 

[THWatson]

Dustin
You can open your form in Design View, select View and then Tab Order and change the tab order to whatever you wish.

It seems that perhaps you have your combo box as the last in the tab order, so tabbing from there will send you to a new record.

Tom

 

[KenReay]

Hi

If THWatson has identified the problem, another solution is to amend the .cycle property of your form to CurrentRecord

It would help if you showed us the code in the combo box I THWatson has not identified the problem

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[uofte]

I am afraid the problem isn't as easy as tab order. Thanks anyway for the response. I am posting the row source language for the combo box.

SELECT DISTINCT Main.Location_Code, Main.Location_Name FROM Main;

Thanks in advance - Dustin

 

[KenReay]

Hi

Have you set the .cycle property of the form as suggested in my previous post?

Do you have any VBA code in the lostfocus event or the after update eevnt of the combo box?


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK