Access Apply Filter action

[ketangarg86]

Hi,

I am using ApplyFilter embedded macro to filter the results in the table. The values comes from multiple fields in a form. If I apply multiple filters, the do not show the combined effect. Only one of the Apply Filter macro's takes effect.



I am unable to put all the search criteria in one ApplyFilter where condition string because of 255 character limit.

Could you please advise what can I do.

Thanks a lot for your help.

[ranman256]

Have you tried :

Test all controls for a possible filter, if not used, skip it...

If not isnull(cboState) then  sWhere = sWhere & " and [state] like '*" & cboState & "*'"
If not IsNull(txtName) then   sWhere = sWhere & " and [Name] like '*" & txtName & "*'"
If not IsNull(txtContact) then  sWhere = sWhere & " and [Contact]  like '*" & txtContact.value & "*'"

'remove 1st And
sWhere= mid(sWhere,4)

sSql = "SELECT * FROM tblCompany WHERE "
sSql = sSql & sWhere
  'apply the sql to the form

   'OR   
'just use the filter

me.filter = sWhere
me.filterOn = true

[ketangarg86]

Thanks dude. BUt I am using embedded macros. I dont know how to use VBA that much. I have a macro to open a data table also. Is there a way I can join multiple ApplyFilter macros in the embedded view.

[June7]

Are these all text fields? Only alternative I know is dynamic parameterized query. Review http://www.datapigtechnologies.com/f...earchform.html