Kelvin

[Kirsten]

My database table(NAMES) of names has three fields in this
order: LAST,FIRST,MIDDLE

The code for rowsource, in the form, for the Last box is

SELECT NAMES.LAST, NAMES.FIRST, NAMES.MIDDLE FROM [NAMES];

The code for the Code Builder is:

Private Sub LAST_AfterUpdate()
[FIRST] = [LAST].Column(1)
[MIDDLE] = [LAST].Column(2)
End

When I enter the last name, the first name inputs
correctly but the middle name stays blank. Also, there
are no duplicates first, last, or middle names

 

[Kelvin]

You code looks good so I don't think it is a code problem. The only thing I
can think is to check the name of the text box. Try renameing all the text
boxes to txtLast, txtFirst, txtMiddle jsut to keep the naming clear and
change the names in the code.

Kelvin