H-SC
asked on
change datasource for grid on timer event
I have a form that has a gridview on it. I would like to have a timer event that fills the datagrid with dataset1 and then on timer next fire would fill datagrid with dataset2
Here is the code that I used in access for this same procedure...
Static B As Boolean
If B Then [Forms]![myform1].Form.Rec ordSource = "rs" Else [Forms]![myform1].Form.Rec ordSource = "rs2"
B = Not B
Here is the code that I used in access for this same procedure...
Static B As Boolean
If B Then [Forms]![myform1].Form.Rec
B = Not B
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
rob,
many thanks for the response... this works perfect!! Also if I wanted to apply this same code to the datasource of a form, how would that look?
many thanks for the response... this works perfect!! Also if I wanted to apply this same code to the datasource of a form, how would that look?
you're welcome =)
a form doesn't have a datasource, but I think you mean datasource of a grid on another form, than the code will simply be;
myForm.myGrid.datasource
a form doesn't have a datasource, but I think you mean datasource of a grid on another form, than the code will simply be;
myForm.myGrid.datasource
ASKER
sounds great rob....many thanks again
static b as boolean
instead of
dim b as boolean