Hello,
I have a form called empInfo and one called empBen they both have pkeys: empid, benid. I am using openArgs method to pass the empid, Fname, and Lname from the empInfo form to the empben form which works and i save it then when i go to open that record again the empinfo form is fine and brings up the record. then i hit the save and open empben button. it does not bring up the record it makes a new one. all fields are empty except the openargs that were passed and it creates a new benid for the record and is not pulling the record already created.
any help would be appreciated
here is the code for the empben form onload
Code:Dim strOpenArgs() As String If Not IsNull(Me.OpenArgs) Then DoCmd.GoToRecord , , acNewRec DoCmd.GoToControl "Text44" strOpenArgs = Split(Me.OpenArgs, ";") Me.EmployeeID = strOpenArgs(0) Me.Text44 = strOpenArgs(1) Me.Text46 = strOpenArgs(2) End If