Access 2010 Forms: VBA

[rob0829]

Hello,

I've done a fair bit of searching online and I can't come to a solution for the problem I'm encountering.

I have a Form that is pulling data from a sorted Query linked to a Table. I have a Yes/No box in the form called "Completed". When I check that box I want the current date to be populated in a field called "First" all the way back through to the Table.

The solutions that I have found online are telling me to use VBA in "After Update" of completed on the Property Sheet but I can't seem to figure out how to link to VBA here, it seems like my only options in Access 2010 are Macros.

Any help would be greatly appreciated!

[pbaldy]

This shows some code:

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

this shows where it goes:

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

[rob0829]

Thanks for the reply, however it doesn't open the VBA Editor like the link suggests. This is what I'm seeing, am I doing something wrong?

[June7]

Is this a web database? VBA is not available to web objects. You typed [Event Procedure] instead of selecting from dropdown because it was not in the dropdown?

[pbaldy]

I'll get out of the way.

[rob0829]

Yes this is a web database, I guess that explains my troubles.....does this mean I'm out of luck? or do I have any other options on doing what I'm attempting?

[June7]

Don't quite understand. Why don't you just enter a date into a date/time field? Is the date field in this form's RecordSource? There is a SetValue method in macros. If the check is removed, do you want the date removed?

Do you really need web db?

[rob0829]

I'm trying to create a database that will be shared among various different users. Items need to be approved by several different people. I was trying to create a form where each person could see what is currently pending their approval and with the simple click of a box they can approve the item and it automatically tracks the date in which they did so.

[June7]

If you have an internal network, a web database is not necessary for that. How do you intend to deploy on web - SharePoint?

[rob0829]

We have an internal network as well as Sharepoint. My intention was to use Sharepoint as it would be easier to get the proper individuals access as well as the use of Sharepoint is being pushed company wide.

[June7]

Then you will be limited to macros behind the web objects. You might find TempVars useful so suggest you research them.

[rob0829]

Ok, thank you for the guidance, I appreciate it!