Automatically update a form

[bmelv via AccessMonster.com]

Hi,
I've got a split form that has 2 date entry boxes up the top ('From' and 'To')
, and the data that is displayed in the table part runs through a query that
uses the 2 dates entered in 'To' and 'From' to filter the data. But whenever
i open the form, i have to hit F5 (refresh) to make the data in the datasheed
part of the form display. is there anyway i can make it refresh automatically?
or 'live update' as i go?

Thanks a lot

B

 

[Piet Linden]

Hi,
I've got a split form that has 2 date entry boxes up the top ('From' and 'To')
, and the data that is displayed in the table part runs through a query that
uses the 2 dates entered in 'To' and 'From' to filter the data. But whenever
i open the form, i have to hit F5 (refresh) to make the data in the datasheed
part of the form display. is there anyway i can make it refresh automatically?
or 'live update' as i go?

Thanks a lot

B

set code to do it in the AfterUpdate event of the textbox controls.

 

[bmelv via AccessMonster.com]

thats not working for some reason, is there some way i can make a macro that
refreshes all when run?

Hi,
I've got a split form that has 2 date entry boxes up the top ('From' and 'To')

[quoted text clipped - 10 lines]
set code to do it in the AfterUpdate event of the textbox controls.