Forms Controls, Methods and Properties

[cfwoodbury]

I am trying to find a dictionary or reference which lists all controls, methods and properties available for MS Access forms.



Is there such a thing?

[joelmeaders]

#1 - The help file
#2 - The object browser in the code window

[rpeare]

There are literally thousands and thousands of items that would meet your criteria and I haven't ever encountered them all in one reference source (even the help file though that's pretty good for basics) If you go to a VB script window within access and look at your references you'll see dozens of them, each one of those references has dozens and dozens of other references.

If you have a specific question regarding controls/references it might be easier to point you in a direction.

[cfwoodbury]

Thanks for the advice.
Specifically, is there a way to toggle a form between form view and datasheet view using code? For example, I want to present a listing of customer records in datasheet view then have a specific record pop to form view when it gains focus by the user highlighting it.

I know I could use a combo box but there are reasons that I want to do it this way.

[rpeare]

Well depending on the number of items in your list you could use a list box to show your 'listing of customer records' in a datasheet type view and when the click on a specific item you can use the primary key to identify the record you're currently on and display all data relating to that item. Look at list boxes and the ON CLICK event of the list box.

[joelmeaders]

I personally use list boxes for everything and never show the datasheet to the end user. There are examples of form/datasheet hybrids in most of the access 2007/2010 sample programs.