Hi,
I all
I have problem with my small app.
I need to make that top 5 combo-boxes to filter data in a table but in a way that you can apply all 5 at the same time.
I tried to find a way but nothing is working. Please help !
Part tracker.zip
Hi,
I all
I have problem with my small app.
I need to make that top 5 combo-boxes to filter data in a table but in a way that you can apply all 5 at the same time.
I tried to find a way but nothing is working. Please help !
Part tracker.zip
build the 'where' clause by cycling thru all the controls....
it executes after a find button CLICK event
if null, ignore.
if not, apply.
Code:'---------------- sub btnFilter_click() '---------------- dim sWhere as string sWhere = "1=1" if not IsNUll(cboST) then sWhere = sWhere & " and [State]='" & cboST & "'" if not IsNUll(cboCity) then sWhere = sWhere & " and [city]='" & cboCity & "'" if not IsNUll(cboZip) then sWhere = sWhere & " and [ZipCode]='" & cboZip & "'" If sWhere = "1=1" Then Me.FilterOn = False Else Me.Filter = sWhere Me.FilterOn = True End If end sub
create a code? Your column is full of codes.
There is code but it is not working.
Is there a way to use macro builder and applyfilter option to make that bombo box to filter that data ?
Did you try adapting code example ranman provided?
For more info on building a search form, review http://allenbrowne.com/ser-62.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.