Need VBA code/"Class Object" for a bound form

[kewelch]

Hi,
I am running into what I'm sure is a simple issue. I created a bound form to a table after adding some additional fields, but the new form does not have any functionality other than being able to enter data on that given record. I want to see the vba code to create the tasks this form should do, like Private Sub Form_Open, and command button functions.



Kevin

[orange]

Please tell us in plain English WHAT you are trying to do --business terms, not Access and tables and bound forms.

[pbaldy]

Also, a form created from scratch wouldn't have any VBA code, but to create some (or view existing) this is where you'd go:

http://www.baldyweb.com/FirstVBA.htm

[kewelch]

@orange "I want to see the vba code to create the tasks this form should do", not plain enough?

Since the form didn't have any vba code, the class object of the form didn't exist under Database Tools > Visual Basic. Thanks pbaldy, all I had to do was Design View > Property Sheet > Event Tab > Code Builder (of any event). Thanks!

[pbaldy]

Happy to help.

[orange]

create the tasks this form should do

this is the unclear part.

As Paul has shown, there are a number of events related to a Form, and its Controls. You can create code for these events to perform tasks, adjust values, clear contents etc as needed in your particular application.

Glad you have it sorted out.

You may find this link interesting/useful
http://office.microsoft.com/en-ca/ac...005186761.aspx

[kewelch]

Thank you for clarifying your previous comment. I am VERY new to access and I have difficulty communicating what it is I need to do. Any formal documentation is helpful, and advice is greatly appreciated. Thanks @orange