I have Office 2003 - I cannot get my head round ADO - DAO ?

[Guest]

I am trying to learn VBA - bought a book which discussed DAO & ADO
I wish to have an unbound form - look up tables etc.in code edit, update.....
Any advice welcome !!!
Al

 

[Guest]

VBA is good; however, I would not recommend unbound forms. The create a lot
more work for you. I used to think unbound forms were better, but I got over
it. Even with bound forms, VBA is very valuable. You use it to react to
events, manage errors and exceptions, and control the behaviour of your forms.

My advice would be to learn how to manage controls in VBA and how events work.
Here is a site with good information on the order of events (very important
to know)
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051867611033