ID = ID opens blank record (1 Viewer)

[Newbie2012]

My form used to work and as I kept adding event scripts now when I click on the ID text field, it doesn't open the linked record, but a blank record with 'Filtered' showing on the bottom navigation.

I guess a question I have is,

• is there an order on which the procedure scripts run
• do they all run everytime, or just the specific event script

===================================
Private Sub Company_Click()
DoCmd.OpenForm "frm Company", , , "[ID] = " & [ID]
DoCmd.Close acForm, "frmCompanyDirectory"
End Sub
===================================
I used to have code on a button on the "frmCompanyDirectory" that added a new record to "frm Company" and that's when the ID = ID stopped working.

I wonder if any one has some knowledge on what has happened here :banghead:

 

[Newbie2012]

Also,
- Form (frm Company) > Property Sheet > Data > Filter = [ID] = 32 (generated record no. but still shows empty record)

 

[Newbie2012]

I solved my problem. I went to Sort & filter > Advanced > Clear all Filters