append query overriding records?

[travismp]

Access 2000

Tbl_TEMP
Tbl_MAIN
Frm_ENTRY

My user opens frm_ENTRY. Which is pulling data from tbl_TEMP. They clean up a few fields on the form. Then click a button which executes an append query which appends the data to tbl_MAIN.

My problem is sometimes when it appends the data it is overriding older data. It is not creating a new line each time. It simply overrides an existing record. Does this make any sense at all?

There are many other forms, queries, tables and macros in this DB. If that matters at all. I think it has something to do with a bound form that is connected to a drop down from a query, but I have no way of trouble shooting this? Where do I start?

 

[KeithG]

Can you post your db? An append query will only add records not update them. It sounds like you have a different problem to me.

 

[The_Doc_Man]

The issue might be that the form's properties allow you to edit the data rather than just append. There is supposedly a way to tell Access you can't edit existing data with a form, only add with it.

You might also look into adding a command button that says INSERT RECORD, which is one of the things a Button Wizard can do for you. In that case, you would use the button all the time. Since there is an APPEND or INSERT preset with the button wizard, no VBA coding would be required, either.

 

[Moniker]

The issue is that he said it's opening up tbl_TEMP connected to frm_ENTRY. If they edit any existing records from within that form, the records will be overwritten. If they add new records, then they will be appended. The fix (although this is a quick fix and your design sounds suspect) is to go to the properties of that form, and then set Allow Edits to "No" and Allow Additions to "Yes".