Using a form to submit data to a table/report 1

[peterose5]

Hi, I'm completely new to access and am trying us it to develop a system I can use at work. I have a form w. 3 combo boxes: Market, Issue, and Description. The Description box limits its options based on the option chosen from the Issue box. At the bottom of the form I have a submit button. After options have been chosen in all 3 boxes, I would like to be able to click the submit button and have it shoot that data into a table where it could be sorted and used to run a report. All of this is completely new to me but I have somehow managed to make it this far. It looks like I may have to use VB but that might as well be chinese to me. I would certainly appreciate any help!! Thanks in advance!!

 

[dhookom]

Is there a reason you are not simply using a bound form?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[peterose5]

I don't guess I know what a "bound form" is. I'm new to access and have never used it before. I read another post where someone said you would need to set the control source of the form to be the table where you want the data to go. And you would need to make each field bound to the table. I did this and it didn't work. I just need some simple instructions on how to make this work, if that's possible.

 

[dhookom]

Select a table or query that you want users to be able to edit or add records. Then select the New Form from the proper button on the tool bar. The table/query becomes the recordsource and text boxes are "bound" to the fields.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[peterose5]

Thanks Duane, I was able to specify the record source for the form. Now, when I hit the submit button on the form, I can get the form to send the data to the proper table. But it only sends the data from the first box (market). The other 2 boxes only send the ID numbers for some reason. Is there anyway I could send this to you and maybe you could take a look at it for me?? Thanks again for all the help!!!

Ryan

 

[dhookom]

I don't accept files on the "first date". We hardly know each other. I usually try to assist in the public forum before I take any discussion or help off-line.

Open the Northwind.mdb sample and spend some time reviewing how forms are used. Come on back with specific questions. If the questions are very closely related come back to this thread. If they are somewhat new, create a new thread.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.