I apologize for butting in especially since I haven't been able to make sense of the thread. However, there may be a syntax error in your initial code snippet which might be what caused your problem.
FindIDProcess = Me.StatusListBox.Column(0)
FindIDCustomer = Me.StatusListBox.Column(1)
FindIDSpec = Me.StatusListBox.Column(6)
DoCmd.OpenForm "F_Contact_Details", , , "[IDCONTACT]=forms![F_MainMenu]!FindIDCustomer", , , FindIDProcess
Forms!F_Contact_Details!ContactViewedAt = Now()
Me.RecentContactsListBox.Requery
End If
You have only posted part of the code so there is no way for me to know if I am right but you seem to be using "Me." when referring to controls on the form so I'm assuming that FindIDCustomer is NOT a control on a form but rather a variable defined in this procedure. If that is correct, then
the DoCmd needs to be:
DoCmd.OpenForm "F_Contact_Details", , , "[IDCONTACT] = " & FindIDCustomer, , , FindIDProcess
Although the Forms! reference can be used to reference controls on a form, it CANNOT be used to reference variables in a procedure so the reference would not resolve to the actual customerID and therefore, the customer would not be found.