Join values from 3 fields

[steph12345]

I am trying to create a part number from 2 look up fields and the ID auto number field.

example: first field would be drop down 2 letters
second field would be from drop down 4numbers
final would be adding the auto numbers to create a unique part number.

Thank you

[zmbd]

1) Ideally, Don't use the autonumber field for anything meaningfull.
2) What version of ACC are you using
3) look at the following on how to use comboboxes
ComboBox Object (Access/Office 2010 )
4) DO NOT USE THE FORM CONTROL WIZARDs in Access 2010 as they default to writing Macro code, this is not VBA, and will not create VBA. Unless you are going to publish to a sharepoint site or using the new NavigationControl, I'd normally avoid ACC-Macro.
5) Show your work and we can tweak things from there, keep in mind that Bytes is not a code writing service.