Help! Open form Where Condition

[joaompc]

I have a table with several records. I want to click on a specific record and open a dialog form with the record details.

I am using this code, but the form opens empty, without the record fields.

Dialog form name is MR Detail

And I want to click on the field "Address" that is a string

Both forms have the same table bound.

Private Sub Name_Click()
Dim stForm As String
Dim stLinkCriteria As String

stForm = "MR Detail"

stLinkCriteria = "[Address]= " & [Address]
DoCmd.OpenForm stForm, , , , , , stLinkCriteria

End Sub

Thanks

 

[PeterF]

Unless Address is a nummeric field your filter will not return records.
Address normally is text so your stLinkCriteria should look like:

stLinkCriteria = "[Address]= [COLOR="Red"]'[/COLOR]" & [Address] [COLOR="red"]& "'"[/COLOR]

 

[joaompc]

Thank you!

It works now!