I use the same form to display different sets of records from a query that includes all records. I limit or filter for different subsets by using the
"Where Condition" in the "Openform" action in a macro.
On the form is a "List Box" which displays a list of all records from which
you can select a record by clicking the value in the "List Box".
How can I limit the "List Box" to reflect just the records in the current
subset of records. I beleive the statement or SQL will go in the "Row Source"
of the "List Box" properties.
Re: Obtaining a filter from a form ... I am curious why you say that you would probably have used an update query...Dim sDate as variant ... Is it possible to obtain a filter, for use in a query, from a form? ... that the user has chosen to display.... (microsoft.public.access.queries)
Re: other table that stores data differently than ADO.Net datatable? ... >> would suggest making some sort of a "search" type of screen and filter... >> criteria for your where clause, that will help slim down your list. ... >>> query the database everytime the user does a scroll (or page up/page ... >>> will display the next N records once the user has reached the last ... (microsoft.public.dotnet.languages.csharp)
RE: Searching Records ... Next, build a set of queries, one for each search ... the particular field the query will search on. ... design a form to display the output of one of the ... >> Selection, Filter by Form, and Apply Filter. ... (microsoft.public.access.gettingstarted)
Two queries ... the Allocated table) I want it to display the product quantity from the ... How do I set up the query to do this? ...Prev by Date: ... (microsoft.public.access.queries)
Re: Displaying query results in form ... use subforms for the filtered queries.... I would like to use the same form to display various different ... > results of each query.... (microsoft.public.access.forms)
