Search (Filter) one form from another

[redbenn]

I am trying to set up a filter form that will filter data on another in a certain field.

Right now I have a text box (Text13) and a Command Button. The Button code is:

Private Sub Command15_Click()
Dim code As String
Dim inboundform As String
 
 
code = "[Input Codes]='" & Me.Text13 & "'"
 
 
DoCmd.OpenForm "Project Inbound", acNormal, , code
End Sub

The problem is, I want to be able to type in part of what I am filtering... for instance the field may contain the value "NEW";"NEW, NEW2, NEW3"; or "NEW, TEST" I want to be able to type in NEW in order to get all 3 records back.

Any ideas?

[puppydogbuddy]

I am trying to set up a filter form that will filter data on another in a certain field.

Right now I have a text box (Text13) and a Command Button. The Button code is:

Private Sub Command15_Click()
Dim code As String
Dim inboundform As String
 
 
code = "[Input Codes]='" & Me.Text13 & "'"
 
 
DoCmd.OpenForm "Project Inbound", acNormal, , code
End Sub

The problem is, I want to be able to type in part of what I am filtering... for instance the field may contain the value "NEW";"NEW, NEW2, NEW3"; or "NEW, TEST" I want to be able to type in NEW in order to get all 3 records back.

Any ideas?

Try this in your code (FYI Chr(42) is ASCii for the wildcard symbol *):

code = "[Input Codes] Like '" & Chr(42) & Me.Text13 & Chr(42) & "'"

[redbenn]

Try this in your code (FYI Chr(42) is ASCii for the wildcard symbol *):

code = "[Input Codes] Like '" & Chr(42) & Me.Text13 & Chr(42) & "'"

worked great... thanks!