Want to create a button in Access 2010 that will use VBA to populate fields in Notes Form

[mhshane]

Hello. I am in uncharted territory when it comes to Lotus Notes so please bear with me.

I do VBA programming in Access but it all pertains to data within that Access database.

In a particular database called WATS, I track every event that happens with company wireless devices. User loses a phone, or cracks the screen, etc. I enter a new event in the Events table in WATS.

I need a way to use that info to populate the fields on a form in Lotus Notes to create an official ticket.

Here is the Notes Form:

http://www.evernote.com/shard/s193/...53e784437491/cfe541bcfa944e3e80ba5daa58f02f4b

Here is the WATS Event Form:

http://www.evernote.com/shard/s193/...8435229b22d7/5033f3473b1c8561c0f48589b1de0137

Data that would be inputted in each field:
[bbox]

Dept = R&D​

Phone Extension = 4098​

Initiating for someone else = [User] from WATS Event Form​

Type of Assistance = Cell Phone/ Blackberry, Phone​

Description = [Event] from WATS Form​

[/bbox]


I would like to place a Button on the WATS Form that will initiate the process.
Notes is always open on my PC

I envision clicking the button on the Events Form, the Notes form opens with the fields populated and I have to click the [kbd]"Submit Assistance"[/kbd] button.

If there is a way to add a command to submit the request that would be awesome.

Thank you for your help. Have a great day.