[AccessD] How to update form source?

Chester,

Instead of copying the data from the source table to another table, just use
the source table itself and apply a filter to the form so only the selected
time period is displayed.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, November 07, 2007 3:32 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to update form source?


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