addiing a record to a table from a form

[seriouslystuck]

Hi All

I need some help! This is my first attempt at a DataBase. I have created a Form in access 2003 that I want the user to complete then on clicking a command button it adds the data as a new line in the table. I have tried the wizard and created the add record button which opens the VB window but Im not sure what code to add..

Any advise would be great.

Thanks

 

[seriouslystuck]

Just to add to this each text box on the form is controlled by a different table as they are all drop down boxes. I have a main table where I want the new record added when the command button is clicked.

 

[alansidman]

If your form is bound to your "main table," then you do not need a command button to update your table. Closing the form or advancing to a new or old record will automatically update your table.

If however, your form is not bound to your table, then you will need to take a different approach. Here is a video tutorial if that is the situation.

http://www.datapigtechnologies.com/flashfiles/addformrecordsnocode.html

Alan

 

[Montez659]

Alan, that tutorial was extremely helpful. I was wondering if you could point me in two directions:
1.) I am having trouble with my listbox repainting when the new record is added. I am not quite sure of the syntax.

2.) I would like to be able to delete by double clicking on an item from the listbox. I am sure it involves some of the same things as this, but if there is a demo and you know, I would like to know.

Thanks for the help!

 

[Montez659]

I eventually found what I was looking for, pretty much within the same thread! here is the link in case anyone runs across this and needs help.

http://www.mrexcel.com/forum/showthread.php?t=470785&highlight=listbox

 

[seriouslystuck]

Thanks most helpful.