Field dependent on another won't keep the data

[Jacques]

Hello all,
I have two fields, where the second field shows a list based on what was
chosen in the first field. Both fields are pulldowns based on SQL
statements. The problem is, even though it works fine, when you go to the
second record and choose something in the first field, it clears the second
field of every other record.

Example

Field 1 Field 2
Data Data works fine, but

Data empties
Data Data this happens after going to the
next record (or clicking on any other existing record).

I have an AfterUpdate event to make sure that its reset, but don't know why
the data doesn't stay when going to another record.


Private Sub BillCont_AfterUpdate()
Me.Accts = Null
Me.Accts.Requery
Me.Accts = Me.Accts.ItemData(0)
End Sub


Thanks beforehand,