Data from Form to Table

[t_dot]

Hi, I am quite new to using access and I have a database set up with date, title and event. I have a table with 2000 entries and have created a form to add new entries to the table -- where lies my problem. I have created an append query with each column of the table that references the table and each references the correct combobox/textfield on the form. I have a "submit" button on the form that runs the query with the data entered on the form. After I click submit, a confirmation message comes up and I click yes to run the query. Then a second window comes up that says "You are about to append 0 row(s)" -- which is not my intention.

It's probably a small thing, but I have never used this append function before and am not totally sure how it runs. What do I need to do to make it append the data that it is passed?

Someone also told me that you can eliminate the query and take the data straight from the form and append it to the table... does anyone know how I might go about doing this instead? Or even how to start? I'm at a loss.


Thanks

[NTC]

A form always has a record source. If the record source is a table - then one adds records just like one does entering directly into the table itself. There is always a new blank record available to start. One doesn't need to complication of an append query.

[t_dot]

Okay, I have eliminated the query and set the record source. When I use the form to enter data into the table, it overwrites the first entry in my table. How can I stop this and make it add it to the end each time?

[t_dot]

Nevermind, I changed the form property "Data Entry" to yes and it solved this -- thanks for your help!