VBA coding to bind the form and table

[shandoo27]

Is it possible to bind a table and a form in MS access 2007 ?? i.e. I want the form to have mutliple rows which are bound to a particular access table . Once I enter values into a particular row and move onto the next row the previous row must be updated automatically into the table . Is it possible using VBA coding of the form ?? If so Please help me out as to how to do it .

thanks for the help in advance

 

[boblarson]

You seriously don't know much about Access do you? If you bind a table to a form then it will automatically save changes to the record when you move to another record. No VBA necessary.

 

[shandoo27]

I am new to access and thus having a lot of doubts. Sorry for being ignorant. Could you guide me as to how to bind a table to a form then without VBA directly pls ?

thanks in advance for the help .