How to use openArgs to pass a value to new records on a different form

[focosi]

I have a primary form (primary key : ID) with a button. The button opens a secondary form showing all records linked to the primary form via the primary key. I would like to fill the ID field in the secondary form by passing "ID" value from the primary form.
I have successfully implemented the openArgs function by passing "ID" value to the first linked record, but I cannot pass "ID" to NEWLY CREATED linked records created on the secondary form..
Any suggestion ?
If it works I would be happy to lock the "ID" control on the secondary form so that it cannot accidentally changed.


Thanks,

[rpeare]

If your first form is still open you can drag that ID to the new form, if the first form is not going to be open when you have the second form over what I would do is have an unbound text box on the secondary form that has the ID field (copy it from your first form when you open the new form), then apply that ID to all new records that are generated on the new form.

[desibabu90]

I have a primary form (primary key : ID) with a button. The button opens a secondary form showing all records linked to the primary form via the primary key. I would like to fill the ID field in the secondary form by passing "ID" value from the primary form.
I have successfully implemented the openArgs function by passing "ID" value to the first linked record, but I cannot pass "ID" to NEWLY CREATED linked records created on the secondary form..
Any suggestion ?
If it works I would be happy to lock the "ID" control on the secondary form so that it cannot accidentally changed.
Thanks,

Is this what you are looking for?
https://www.accessforums.net/forms/s...rds-15377.html

check the last post and there is a link to site that i got it from.

[focosi]

@rpeare : what do you mean by "drag" ? At the top of my head drag&drop is not supported in Access forms.. or maybe I disabled some function??? Anyway, this is not a solution to me. I want to pass the value and lock the control every time I create a new linked record, I don't want to copy it manually and leave the field prone to accidental changes made by users. I have succesfully implemented passing the argument from the primary to the secondary form with the following code :

on the primary form :

Private Sub Donatori_Click()
On Error GoTo Err_Donatori_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Dati donatori"
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria, , , Me.ID
Exit_Donatori_Click:
Exit Sub
Err_Donatori_Click:
MsgBox err.Description
Resume Exit_Donatori_Click
End Sub


on the secondary form :

Private Sub Form_Load()
Dim strOpenArgs() As String
If Not IsNull(Me.OpenArgs) Then
strOpenArgs = Split(Me.OpenArgs, ";")
Me.ID = strOpenArgs(0)
End If
End Sub

What I need is to pass the argument when I create a new record (still linked to same ID in the primary form) on the secondary form.. Any idea ?

@desibabu90 : maybe I'm wrong, but your video didn't help me.....

[desibabu90]

@rpeare : what do you mean by "drag" ? At the top of my head drag&drop is not supported in Access forms.. or maybe I disabled some function??? Anyway, this is not a solution to me. I want to pass the value and lock the control every time I create a new linked record, I don't want to copy it manually and leave the field prone to accidental changes made by users. I have succesfully implemented passing the argument from the primary to the secondary form with the following code :

on the primary form :

Private Sub Donatori_Click()
On Error GoTo Err_Donatori_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Dati donatori"
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria, , , Me.ID
Exit_Donatori_Click:
Exit Sub
Err_Donatori_Click:
MsgBox err.Description
Resume Exit_Donatori_Click
End Sub


on the secondary form :

Private Sub Form_Load()
Dim strOpenArgs() As String
If Not IsNull(Me.OpenArgs) Then
strOpenArgs = Split(Me.OpenArgs, ";")
Me.ID = strOpenArgs(0)
End If
End Sub

What I need is to pass the argument when I create a new record (still linked to same ID in the primary form) on the secondary form.. Any idea ?

@desibabu90 : maybe I'm wrong, but your video didn't help me.....

i wasnt talking about the video. i was talking about this webpage:

http://bytes.com/topic/access/answer...ate-new-record

look at the comments section by MMcCarthy.

[focosi]

i wasnt talking about the video. i was talking about this webpage:

http://bytes.com/topic/access/answer...ate-new-record

look at the comments section by MMcCarthy.

got the point, but this doesn't solve my troubles.... Maybe I should I use a custom button+VBA to create a new record instead of the default starred button at the bottom of the form window ?
Thx

[desibabu90]

im fairly new to access so i am not sure..i just thought that the solution I posted was what u were looking for.. can you post your database here so maybe someone can look at it?

[focosi]

I actually fixed this by myself since the solution was simpler than I thought.
I just put in the AfterUpdate event of my form (not the control) ...

Me.ID.DefaultValue = """" & Me.ID.Value & """"

...to pass the ID value from the current record to all newly created records linked by ID to the primary form.
Thanks for help anyway!

[desibabu90]

oh okay.. glad it worked out!