Newb question - filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there, I'm building my second ever app with access. I was wondering if
someone could help my up with queries/filters. What's the difference?

I need to be able to copy the filter for a continuous form to a single view
version, but my continous form is based on a query that does all the
"filtering". Do I take all the WHERE clauses out of my query and put them in
the Filter property field or what??

Please help, this is confusing.
 
You can use the same query for the (single) NormalFormView, i.e. both Forms
have the same underlying DataSource. The NormalFormView presents only one
"row" from the Form's Recordset (DataSource) at a time while the CtsFormView
presents as many Records as can be fitted on the Form's window.
 
Hi, thanks for your reply.

That same form can be accessed from about three different areas. Which is
why I thought it would be easier to dynamically change the filter.
 
Back
Top