If those "fields" are actually Textboxes then set the "EnterKeyBehavior"
property to False for each Textbox.
And as Joel pointed out, the tab order must be set correctly.
--
Jim Cone
Portland, Oregon USA



"Mark Stephens"

wrote in message
Should be simple but I cannot figure it out... is there a way to use the
enter key to navigate records? Basically I have a user form and am loading
variables in it's fields based upon the values in a spreadsheet.

I want it so that each time the enter key is pressed the cursir drops a row
and the user form is then repopulated with the data.

I know how to use accelerator keys to speed up entry but i cannot figure
out how to accompplish this simple task. Any help much appreciated, thansk
and regards, mark