DoCmd Driving me Nuts!

[Matt via AccessMonster.com]

I have the following code on the dbl click event. It works great in another
database I created. However it returns a blank form when I use it in a new
database.

It should return the record with the matching DetailsID in frmEngLog. I only
have 5 records in my test database and there are all unique. When I execute
the code it opens the form but it's blank. HELP!

Private Sub DetailsID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim strFilter As String

stDocName = "frmEngLog"
strFilter = "[DetailsID] = Forms!frmEngLog!DetailsID"

DoCmd.OpenForm stDocName, acNormal, , strFilter

End Sub

 

[Douglas J. Steele]

If DetailsID is numeric, try:

strFilter = "[DetailsID] = " & Forms!frmEngLog!DetailsID

If it's text, use

strFilter = "[DetailsID] = " & Chr$(34) & _
Forms!frmEngLog!DetailsID & Chr$(34)

or

strFilter = "[DetailsID] = '" & Forms!frmEngLog!DetailsID & "'"

Exagerated for clarity, the second one is

strFilter = "[DetailsID] = ' " & Forms!frmEngLog!DetailsID & " ' "

 

[Matt via AccessMonster.com]

The following worked.

strFilter = "[DetailsID] = " & Me!DetailsID

Thanks for the help

If DetailsID is numeric, try:

strFilter = "[DetailsID] = " & Forms!frmEngLog!DetailsID

If it's text, use

strFilter = "[DetailsID] = " & Chr$(34) & _
Forms!frmEngLog!DetailsID & Chr$(34)

or

strFilter = "[DetailsID] = '" & Forms!frmEngLog!DetailsID & "'"

Exagerated for clarity, the second one is

strFilter = "[DetailsID] = ' " & Forms!frmEngLog!DetailsID & " ' "

I have the following code on the dbl click event. It works great in another
database I created. However it returns a blank form when I use it in a new

[quoted text clipped - 16 lines]

End Sub