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

 

[dhookom]

You should provide additional information such as your table structure, form and control names, Row Source, etc.

Why are you not simply using bound forms/subforms?

Duane
Hook'D on Access
MS Access MVP