Problem appending Data to Database from a form

[ssalem]

Hi,

Again I am confused. I had a form that I am adding a record to the database. On form Load I am moving to the end of the database and adding a new record. It was working correctly but was not behaving the way I wanted it to because if you quit the form without completing it it would save the record. I did not want this to happen. So of course I tried different things. I unbound the form and tried thru SQL to insert the information from the form into the database. Again I was having issues did some research and decided I wanted to bind the form again.



I have bound the form again (i think) by changing the record source to my table.

But now it will not add to my table. When I use a save or add button it will not append. I have fooled around with several settings but to no avail. I did go to the table and am able to add a record directly to the table.

I also have a maintenance form that functions correctly with update/add/delete records. I tried to see if all my settings were the same and they are. But does not seem to be working. I tried creating a new form from the table, cut and pasted my fields from one form to the other and still is not working. Not sure why unbinding the form and then rebinding it would cause this problem.

Any insight?

Thanks,

[Missinglinq]

Not a clue from the information you've posted. I think you'd really have to attach a copy of your file (with any confidential data deleted) to a post so that we can 'look' inside.

As to your original problem, once you get the Form back to saving Records, again, you can do a number of things to only save a Record through explicit actions of the user, such as validating that all needed info for a 'complete' Record is present, or simply asking the user, before saving the Record, if they want to save it.

But let's get the Form working, again, before tackling that.

BTW, wanting to control the saving of a Record is the leading reason posters give for going the Unbound Form route, and it's totally unnecessary; almost anything that can done with Unbound Forms can be done Bound Forms, and with less work!

Linq ;0)>

[ssalem]

Ok sometimes I feel really stupid.....I was also working on fixing some problems with the way it was displaying data. I wanted a calculation to be saved to the table as a new record.... (the difference between the table ending inventory to the physical inventory) and add the new record to balance the differences and add it as spoilage/variance. My problem was when I changed the field to do calculations it changed the record source....(dah). So when I saved the record it had nothing to save.....so now I added all the fields I need, save my calculations to the input fields which are invisable to the user. This way also the undo button works correctly because it does not save the information if someone hits the quit button before entering all the information and hitting the save button. I can do all my validity checks before I save them to the table fields. Problem solved. Amazing sometimes your looking too much at the settings when the most obvious is right in front of you.