I'm trying to build some code to capture certain fields within an Access Query and place them into fields within a Lotus Notes form.

I have the code to launch and send the form, and i can hardcode the content of the form fields but I'm having problems extracting the data from the Access Query to then place this within the Notes Form fields.

Any Suggestions?