Changing Recordsource

[snorky]

Dear All,
I have a form with a DataGrid on it which points to an invisible ADO control on my form .The ADO control RecordSource property points, initially, to a blank table in my Access db but during the program execution I want to look at other tables in the original database. I have tried changing the ADO control's RecordSource property and then re-showing the form with the datagrid on it but the grid is still blank (from the first table). How do I get the datagrid to show the data from the second and any other tables ? ? ?

Thanks...

 

[tomschafer]

Place this in your code after the line where you've changed the RecordSource...

Me.Requery

 

[snorky]

What does the Me. relate to, if I put that in the formload it tries to relate it to the form and errors. Is it the Datagrid or the ADO control that I'm requerying ? ie
frm_Main.ADCOC1.Requery ???

 

[tomschafer]

It is the form if you need to requery the ADO Control the code would be..Me is simply a dynamic way of returning the current form name.

Me.ADCOC1.Requery

 

[snorky]

Unfortunately that's not it. Requery isn't a method of a form and so errors .Which makes sense as the form isn't data-bound to anything . The grid and ADOcontol are - but it doesn't work if I requery either of them ???

 

[snorky]

FOUND IT ! What I need to do was add

frm_main.datagrid1.Refresh


Thanks anyway !

 

[tomschafer]

Then you should be able to use...

Me.datagrid1.Refresh

 

[snorky]

Yup -thats the one !