Creating Access 2000 database

[ekxpres]

I'm trying to create a basic monthly access database. I create my tables and the form to input data. The trouble I'm having is that if I go back to an exsisting record to input data for a different month, I overwrite the records instead of creating new records for my new month. How can I use my fields to input data for different months and still keep the old data? Thanx, any help is appreciated.

ekxpres

 

[lespaul]

What does the query look like that's updating the data?

Leslie

 

[willir]

ekxpres

On the form, are you advancing to the next record with the navigation arrows. By default, Access will place the navigation arrows at the bottom of the form. One navigation icon, right arrow with a "*" will create a new record. You can do the same thing from the Access menu -- Insert -> New Record.

Richard