MS Access - autocomplete help

[osp001]

I have a form that has a subtable in it for data entry. The first column draws its list from a table (compounds), and the second column is a manual entry (quantity).
I've been trying to figure out how to autocomplete when I start typing in the first column; I'd like to be able to type in "Abc" and have "Abcde" come up so I can select it and tab onto the next column.
Can anyone give me any pointers how to do this?
Thanks!

 

[GoDawgs]

Access automatically does that I believe...the only time that won't happen is if the first letters you type are in multiple records (ie "ABCD" and "ABCE&quot. I have a combo box that automatically drops down once you start typing...that's easy to do, just put this in the KeyPress event of the combo box:

Me.ComboBoxName.Dropdown

Hope that helps.

Kevin

 

[osp001]

OK; I gave that a shot, and it didn't work. It gives me an error each time, and can't find a macro in the system that works using "dropdown."

I currently have the list box set as a pull-down menu; but when I start to type in a given compound, it doesn't auto-complete.

Sorry to be so thick-headed; I'm learning Access on my own, and the books just aren't that helpful for some of these applications.

 

[GoDawgs]

Are you using a Combo Box or a List Box?

 

[osp001]

Combo box. D'OH! Should have specified that. :-/

 

[GoDawgs]

It should work then...if you go to the properties of the combo box and go to the On Key Press event, then type in the code I gave above (dropdown is a method of a combo box).

 

[osp001]

I've tried that- and I get an error: "Microsoft Access can't find the Macro 'Me'". :-/

 

[GoDawgs]

Are you in the code window? When you click in the On Key Press event box there should be three buttons to the right...click on that...then you should end up with this:

Private Sub ComboBoxName_KeyPress(KeyAscii As Integer)
Me.ComboBoxName.Dropdown
End Sub

-and make sure you substitute in the name of your combo box for ComboBoxName