autocomplete a field

[gheyman]

I want to put a field on a form where the user enters a Part number. I want the filed to finish entering the data as the user starts to type in the part number.

Example of there is a part numbers in my table named ABCD, ABCD1, ABCD12... And the User starts entering "A" I want the field to fill in with ABCD and so on.

Can someone give me some guidance? Do I need to create a separate table that just has Part numbers so that the field on the form is uses it as a list? can Access use the existing data from the table field where entering the part number......?

Note they need to be able to enter a new part number if it doesn't already exist. I would hate for them to have to open up a separate table to enter the new part number so that it appears in a Pulldown.

Any suggestions or guidance is appreciated

 

[CalcSux78]

Here's an article that helped me: https://www.contextures.com/xlDataVal10.html

 

[gheyman]

Thanks, but that's for Excel. Or did I miss something?

 

[welshgasman]

A combo work that way. ?