i need a guide on how to mange forms for data insertion

[amd711]

i am a newbie, i use split forms for data insertion in tables in a relational db

i chose the table then click "split form" so that textboxes are binded to the table. however i am facing a problem of the error messages that keep to come up because of a primary key was not inserted or because of the relations between tables or because of a field "Required" property set to yes.

this messages don't go away no matter i did

how to deal with it?
and what is the best way for adding, editting, deleting, or searching for data in such situation?

[June7]

If the primary key were an autonumber field then missing pk would not be an issue. If you don't want a field to be required then change that property for that field in table. No idea why table relations are an issue without knowing more about data structure.

[amd711]

i need to add the following buttons for the previous form for ( add new - delete - search - cancel )

"cancel" means to cancel the current insetion and be ready to enter a new record

what vb code to consstruct them?

i also need to stop pressing tab at the last textbox to add a new record

[June7]

Do some research on this, attempt code, and when you have specific issue with the code, post for analysis.

Google: Access vba move to new record

[amd711]

i found topics that program the whole form from scratch, but not when textboxes are binded to the table

[June7]

Don't know the code you found so don't know why that would make a difference.