Yeah, I think so too.
However, my access keep complaining about dim-ing db as database and rs as recordset. My solution at the moment is to dim them as objects, and let my access to late binding the correct object type. I thought that I am having this problem because i am just using DAO.
To asjohnson:
Before I know anything about VBA, I used to open a form at adding new record. So after I finish entering all the information and close the form (or going to the next record), it add the record into the table automatically.
To have more control of it, you may want to add some codes in Forms_BeforeUpdate to make sure that the information that has been entered are input correctly.
I found this method is too buggy, so i would rather to put more time on doing VBA later on.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.