title: SQL and MS access- filtering of the data on the form
body: <p>I am using SQL 2005 as backend and MS Access as frontend.</p>
  
  <p>Now, I get all my filtering of the data with views and no problems so far but I came accross some issues.</p>
  
  <p>In access I had a form and on that form I had a field1 which I used to filter the data I wanted in that form with query. Example: Last, First Name or DOB. In Access I used the Expression builder to point the query to that field and I got my filter. 
  Now how do I do it in this new environment since when I create view (In Access) I can not filter on that field.</p>
  
  <p>I was thinking on sp but I am not sure how do i go about it.</p>
  
  <p>Any ideas?</p>
  
  <p>I was thinking on sp but I am not sure how do i go about it.</p>