Where can I find info on how to reference in vba?

[jaad]

I have been trying to build a database for the past year and time after time I always end up with the same problem. I can never write the right combination of reference for a control or a form or a subform and so forth. is there a link somewhere where it would teach me how to reference properly in VBA? thanks

[Lysander]

The Access Help system gives lots of examples of how to reference various properties of controls and forms etc.

A very good book is the Access Developers Handbook by Litwin, Gitz and Gilbert

[malcolmk]

could try http://www.mvps.org/access/forms/frm0031.htm try google it will throw up all sorts of usefull sites.

[Stewart Ross]

We have an Insights article on Referring to items on a subform which may help you to understand how to write subform control references in VBA.

-Stewart