new record open form

[tubar]

one the first form the user creates a record (recording artist). the second form is a data entry form that the user inputs data to except the field recording artist, which has been already filled out.

its like i need a "refresh" after creating the new record and before opening the second form...can someone help

[pbaldy]

You probably need to save the record:

If Me.Dirty Then Me.Dirty = False

[tubar]

i used the following code but got a new record on the following form

Private Sub Command6_Click()
On Error GoTo Err_Command6_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "INPUT RECORDING ARTISTS"

If Me.Dirty Then Me.Dirty = False
stLinkCriteria = "[RecordingArtistName]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command6_Click:
Exit Sub

Err_Command6_Click:
MsgBox Err.Description
Resume Exit_Command6_Click

End Sub

[pbaldy]

First, what is the Data Entry property of INPUT RECORDING ARTISTS? Second, those two fields don't look compatible based on the names (RecordingArtistName & ID); are they the same data?

[tubar]

1. is set to no and 2. yes they are the same data. ID refers to the id of the artist name

[pbaldy]

Then I don't see why it's not working. Can you post the db?