Recent content by AccessNubie

Thanks... i'll give it a try.

I can certainly edit record in datasheet view, but one field is Memo and can contain lots of text. It would be more user friendly if i could select one record and open it in the form view to edit.

My program has dynamically created a SELECT statement to pick a subset of records in a table and displayed them in Datasheet view. I want to select one of those records and open in a form for editing. How to do it?

I'm a brand new Access user... so take what i say with a lot of skepticism. If i understand your problem, try this (i'm using Access 2010). Go to File > Options > Client Settings > Behavior Entering Field and set to 'Go to Start of Field.