Forms - Select record in list box and open form populated with that record

[mikael]

for search form, i have textbox as a user input, n list box to filter the record..


what i really want is to double click the highlighted record to display full record which in other form.. here is the code

  
    Dim stDocName As String    Dim stLinkCriteria As String


    stDocName = "USER"
    
    stLinkCriteria = "[Service Tag]=" & Me![search]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

however, the code run to be error at stLinkCriteria..
i dont know how to configure the problem since i just copied the code from my research.
or do i have another way so i can display the selected record from listbox.. anyone pls help me.

[Rod]

Is [Service Tag] numeric or text? What's the error?

[Missinglinq]

If it's popping an Error on

stLinkCriteria = "[Service Tag]=" & Me![search]

which uses the correct syntax if [Service Tag] is defined as a Number Datatype, one has to assume, given its name, that it is actually a Text Datatype, in which case the correct syntax would be

stLinkCriteria = "[Service Tag]='" & Me![search] &"'"

although you don't need the Square Brackets around Search, and I'd probably write it simply as

stLinkCriteria = "[Service Tag]='" & Me.search &"'"

Linq ;0)>

[mikael]

thanks Missinglinq.. it help much...