Main Form passes ID value, but Details Form shows as a New Form

[Pada]

In main form, I try to pass an ID value to the Details form using this line of code.



DoCmd.OpenForm "frmMain", acNormal, , , , , ID.Value

Then in my Details form, I have the following codes.

Private Sub Form_Load()
      Me.Filter = "[ID] = " & Me.OpenArgs

End

Private Sub Form_Current()


    If NewRecord Then             'NewRecord is a built-in property of Form class.
        New_Record = True        'New_Record is a declared Global variable => it says New Record is True that is not right!
    Else
        New_Record = False
    End If

However, when I click on the ID on the main form, although ID is passed to the Details form, it looks like the Details form doesn't receive it and it shows as a new blank form with a new ID that is an auto-number datatype in the
table (record source) underline the Details Form.

The weird thing is my friend has NO issue with passing the ID value to the Details form. I copied exactly her versions (frontend and backend) to my computer, but it ends up with faulty described above.
I did compact and repair, deleted copies and did copy those versions again, and checked Reference, I still got the new blank form instead a Details form showing existing data.

Please help! Tthank you!

[Welshgasman]

You are setting a filter, but not setting the filter on?

I would also use Me. for form controls/properties.

[June7]

If you really simply copied files and did not change anything, should work same.

Could provide db for analysis. Follow instructions at bottom of my post.

Could simply open detail form filtered by WHERE CONDITION argument of OpenForm instead of complicated Load and Current coding.

[Pada]

If you really simply copied files and did not change anything, should work same.

Could provide db for analysis. Follow instructions at bottom of my post.

Could simply open detail form filtered by WHERE CONDITION argument of OpenForm instead of complicated Load and Current coding.

Hi June7, yes, I really simply copied files and that was it. That was why I said it's weird.

I update the opening the Details form as following.
The code below is from the ID_Click event (when I click on the ID control on the form, it takes me to the Details form)

DoCmd.OpenForm "frmDetails", acNormal, , , , , Me.ID.Value           'I added Me in the front of ID like Welshgasman said, but it still the same.

[June7]

I wouldn't have expected that to make a difference.

Maybe you should try my suggestion.

[Pada]

Hi Welshgasman and June7,

I think I have found the issue. The culprit is the query's relationship (record source of the Details form). There is one field in the table that has no data. That is why the form pulls no record. I suspect my friend links her frontend with ANOTHER the backend (that has data), NOT on the backend version that I copied. Her fault!

Thank you both of you trying to help. Appreciate it.

[jojowhite]

what do you mean by "Detail form", is this a subform on your Main form?
if it is you change the code of the "Detail form" Load Event to:

Private Sub Form_Load()
Dim id As String
id = Me.Parent.OpenArgs & ""
If Len(id) Then
    Me.Filter = "ID = " & id
    Me.FilterOn = True
End If

[Micron]

if it is you change the code of the "Detail form" Load Event to:

Except subforms open/load before the main form, so the subform will not be able to reference anything having to do with the main form.

[jojowhite]

Except subforms open/load before the main form, so the subform will not be able to reference anything having to do with the main form.

that is not entirely true.
the code i posted is Tested on the subform on a Main form.