|
Subject:
|
Update a query by clicking on a tab
|
|
Posted By:
|
techsp
|
Post Date:
|
8/15/2005 5:34:59 AM
|
I have several queries that I have put on various form tabs what I need to achieve is each time i click on a form tab it re runs the query to show the up to date information. I hope this make sense!
|
|
Reply By:
|
SerranoG
|
Reply Date:
|
8/16/2005 7:33:03 AM
|
On the tab control's ON CHANGE event, requery the controlsource of your subform. For example,
Select Case Me.ctlMyTabControl
Case 0
Me.sfrMySubForm0.Requery
Case 1
Me.sfrMySubForm1.Requery
Case 2
Me.sfrMySubForm2.Requery
End Select
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
|
