how to update tables by inputing data in forms

[Graham R Seach]

Uhm, bind the form to the table?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Guest]

hi,
simplest way is to bind the table to the form.
if you have multiple tables, then use a temp table that
gets it data from a append query or recordset or sql
statement then bind the temp table to the form. once you
have updated the data, you would have to update the table
from the temptable.