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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on a filter on an open form 2
Which is faster? 6
Filter Form doesn't close 2
Filter parameters asked on first open, subsequent unfilter/re-filterdoesn't re-fill the parameters 2
how to remove filter created by synchronized combo on continuous f 8
Performance question 4
Using Combo Box on Form with Sql view to filter 5
Excel Export Filtered Form Data To Excel 0

Back
Top