Autocomplete Combo Enter/Tab behaviour

[andymartin3186]

Hi
I have a field on my form called Manufacturer which was a standard text box.
I decided to change it to a combo box with a row source as:

SELECT DISTINCT Manufacturer
FROM Job
ORDER BY Manufacturer

It works great, and suggests manufacturers whilst typing which is exactly what I wanted it to do, as well as allowing me to add new ones if they don't already exist.
The minor issue is if you tab or enter once you have chosen the manufacturer, the form goes to what appears to be a new record page.
If you click out the combo box it is fine.
Do I need to add some code on update to stop this happening?

 

[Gasman]

What do you have in Options?

 

[xavier.batlle]

When you have changed the textbox control to a combobox, the combobox tab order of the control has changed and now is the last control in the section.
You have two options to avoind going to a new record:
- Reorder the controls on the tab order option on the form section (surely detail section)
- Change the Cycle property on the form section to Current Record

 

[Pat Hartman]

You have two options to avoind going to a new record:

You should do both things.