Hi Ck,

I having a problem with using the recordset .MoveNext in access.
I have a form and using Combo Box to select and update data to certain
table. But i having a problem with using .MoveNext function.

Ummmm. This is a WORD.Newusers newsgroup? Perhaps you should ask this in
an ACCESS group dedicated to programming (VBA or DAO or ADO)

FWIW I don't understand how you're using the MoveNext function in this
context. I should rather think you ought to be able to access the record
directly, using a primary key.

but in any case, I'd check whether the records are sorted the same way
as they appear in your list vs. the order they're in in the recordset,
if you're always getting the "wrong" record, and there's no pattern to
it.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)