[AccessD] How to update form source?

Instead of running a query to update the table, change the recordsource of
the form and/or its filterBy. I have used this approach several times and it
works very well.

A.

On 11/7/07, Kaup, Chester <Chester_Kaup at kindermorgan.com> wrote:
>
> I have a form on which the user clicks a button to see 90 days worth of
> data from a source table. When the button is clicked a query runs that
> puts 90 days worth of data in a table. Another form then opens and
> displays this data. On the top of the form are two text boxes. One text
> box contains the start date of the data and the other the end date of
> the data. These boxes can be edited allowing the user to see some time
> interval of data other than 90 days. When the date is changed in the
> text box code attempts to run a query to update the table the displayed
> data is based on. The query will not run though because the table is
> open. I could use some ideas on how to do this. Thanks.
>
>
>
> Chester Kaup
>
> Engineering Technician
>
> Kinder Morgan CO2 Company, LLP
>
> Office (432) 688-3797
>
> FAX (432) 688-3799
>
>
>
>
>
> No trees were killed in the sending of this message. However a large
> number of electrons were terribly inconvenienced.
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>