Problems with recording data in table through forms

[Mumus]

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.

 

[jenp]

You just need to make sure your second (etc) form knows which field to put the info into... you can do this by making sure each record has a primary key that is represented on the form - either hidden or not - and then linking them in the event called by the button. The VB code could look like:

Private Sub open_field_2_form_Click()
On Error GoTo Err_open_field_2_form_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

// change stDocName to the name of the form you want the button to open
    stDocName = "field_2_form"
    
// [ID] should be whatever your autonumber field is called in the table - this
// really should be an autonumber and not a user-modified field.
// Me![ID] references the ID field on the current form
    stLinkCriteria = "[ID]=" & Me![ID]

// close the current form
    DoCmd.Close

// open the next form making sure the link criterion is met
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_open_field_2_form_Click:
    Exit Sub

Err_open_field_2_form_Click:
    MsgBox Err.Description
    Resume Exit_open_field_2_form_Click
    
End Sub

Being able to put the data on the correct line *should* fix your second problem, too... unless I'm misunderstanding it.

Hope this helps!

 

[neileg]

Why do you need a new form for each field? I would expect to see all the fields on the same form.