Data Entry - Not always taking in database

[jfregelette]

I am having a problem where I have a form that I enter data into. Sometimes when I enter the information it will add a record to the table and sometimes it doesn't. It doesn't put the information in the table more times than it does.

I have tried to enter the information outside the form and it still does the same thing.

Do you have any suggestions of what I can do to fix this.

Thanks

 

[Geoff Convery]

Is the form a multiline one? If it is you have to exit from the new record before you close the form; the easiest thing being to click on another row (it doesn't matter if it's an existing one or the blank row that appears when you start creatin a new one). I've tried all sorts of things to avoid having to do that but have never quite sorted it! Try some careful experimentation along these lines, preferably with a test copy of your database.