Form to table question

[manin]

Hello, I just started to build an access database.
I have ta table, and I want to build a form so someone, can add record to the table.


I tried to create new form, from the table, but when change with tab from the last text box to the other tab delimited object,
the record is added.
I tried to create a new form, add textboxes, and bound them to the table, but the same happened again...
I want to have the new record into the textboxes, and with a button, could be added...
Thanks for advance...

[June7]

Don't understand. What is 'other tab delimited object'? Do you want to provide project for analysis? Follow instructions at bottom of my post.

If textboxes are bound to fields of RecordSource, the entries are passed directly to table. A record is committed to table when move to new record, close form, or run code. Sounds like the form behavior is normal.

[manin]

The database tables, fields are in greek.
I renamed to "new" the form I mentioned above.
If you use tab, when the tab goes again to the first field (textbox), all the data that are
in the fields, are recorded to the table.
I want to deactivate this, function.
Then with an "insert query", i imagine that I will have the result I want...

[RagJose]

Open your form in Design view, go to Form properties, "Other" tab, look for "Cycle" and change it from "all records" to "current record". This will prevent a new record to be written when you tab from the last control. Hope this is what you were looking for.

[manin]

Open your form in Design view, go to Form properties, "Other" tab, look for "Cycle" and change it from "all records" to "current record". This will prevent a new record to be written when you tab from the last control. Hope this is what you were looking for.

Yes, that's it.
Thank you