Problems With Recording Data In Table Through Forms

Hi All,

This is my first post on this forum...:)

I'm having the following problems:

I have a table with "n" fields.
Each field will constitute a form.
Each form will have a button which will open the next form.
Basically I want to record new data into the table (database) through FORMS.
What I am unable to do is to record data on the same line in the table !!!
What I have so far is that I am able to move to the next record when creating a new NCR but the rest of the data (fields) are going to overwright the first record in the table (first line).

I would attach my database here but the file size is bigger that permitted.
If someone interested I could foward it on e-mail.

My second issue is that after recording data into the table I want to be able to modify that data through a form. When a certain NCR number is choosed this will pop-up the NCR form with all fields from the table.


Any suggestions are more than welcomed.

Thanks for your help...

Mumus.