manually adding entries to a table

[striker73]

What is the syntax to manually add an entry to a table? Let's say I have a text box with a value in it and I want the user to hit a cmd button and have that entry added to a table, what would I use? Thanks!

 

[striker73]

How can I create my own recordset and have the form linked to that recordset? How can I filter values in a table to display on a form? For example, my table is set up like this:

Customer_ID Date Amount
----------- ------- ------
1 1/1/00 $2000.00
1 2/1/00 $3000.00
1 3/1/00 $2500.00


I want to have a form that will have text boxes, labeled by month (jan-dec) that will show all of customer_id #1's sales for year 2000. For example:

Customer Name: ABC Corporation
Year: 2000

January: $2000.00
February: $3000.00
March: $2500.00



Any suggestions on the best way of doing this? I was thinking about linking the form to a query, but I want the user to be able to edit the entries. I was thinking I could do it dynamically, but it's getting pretty complicated.... :-I