dominicg123
Technical User
This code is part of a procedure to filter my record base a combo box.
If Not IsNull(Me.FtlTypeDoc) Then
strWhere = strWhere & "(right([Linked_Doc], 3)= """ & Me.FtlTypeDoc & """) AND "
End If
Linked_Doc is a path to certain files and FtlTypeDoc is a combo box with a list a extention (jpg,gif,tga,doc....)
When I apply my filter I get a parameter box asking for linked_doc
Thank you for your help in advance
If Not IsNull(Me.FtlTypeDoc) Then
strWhere = strWhere & "(right([Linked_Doc], 3)= """ & Me.FtlTypeDoc & """) AND "
End If
Linked_Doc is a path to certain files and FtlTypeDoc is a combo box with a list a extention (jpg,gif,tga,doc....)
When I apply my filter I get a parameter box asking for linked_doc
Thank you for your help in advance