field into a drop down box

[Frank]

is there a way to make one of my fields a drop down box so
i dont have to input the information over and over again,
i would be able to just click a drop down and choose a name

 

[Pavel Romashkin]

You shouldn't do it to a *field*, you should to it to the combo box
control on your data entry form. Combo box has RowSource property - this
is where you will enter something like

SELECT DISTINCT Name FROM MyTable

Cheers,
Pavel