How can I implement a Form which has a DataGrid
displaying data from MS Access/SQL Table
but instead of updating using the Data Grid I would like to be able to
bring up a Form for Data Entry as there are too many Columns for datagrid

Also this enables me to exclude columns the user should see as well as
implement lookup
from another table for some columns

Mike,

See this sample on our site it is quiet complete except the loading of the
dataset and the updating, which is the same as with a datagrid.

It has two buttons, you can of course add a button for go to end and go to
start, update etc.

http://www.windowsformsdatagridhelp.com/default.aspx

I hope this helps,

Cor