Macro to submit data from a form to a table

[mohecan84]

Hi guys,

This is my first post to Tek-Tips. I am fairly new to the VBA scene. This is my first real app that I am creating in Access. have run into some troubles with my VBA script to submit the info selected on the App form to the table provided.

I have 2 list boxes where I need to provide for up to 40 selections each. In my current script I am not using any loops as I am still researching into how I am going to accomplish that. I am just looking for some insight as to what would be the best practice for submitting the data from the form to the table.

Your assistance is greatly appreciated.

kind regards,
Mohecan84

 

[SkipVought]

Mohecan84,

Welcome to Tek-Tips!

You will get much better results, posting MS Access questions in one of the many MS Access forums like forum702 or forum705.

Good luck!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[mohecan84]

Thank you Skip, will be sure to do that.