How can i get a data grid on a form that can change data sources?

[OrangeWire]

I would like to have a form laid out in the fashion of:

Buttons on top for different queries
Data grid below with changing data based on the button choices.

Is this possible?

I have been unable to get a datagrid onto my form -- i am however able to create a form that is 100% a data grid (no actual form work space) but that isnt what i really want.

I was thinking if i created a forum that was the datagrid then made it a subform of a parent form that might do the trick, but im not sure of teh optimal way this should be completed.

Any comments would be Awesome.

thanks!!

 

[PaulF]

one method is to create a subform for each Data grid that you might want to display.. place them on top of each other in your main form, and set the Visible property of each of them to "No".... then based on the command button choices... set the correct one's Visible property to "Yes" and set all the remaining visible properties to "No"...

Another option is one subform, that you change the RecordSource of based on the button selection.

HTH
PaulF

 

[OrangeWire]

Thank you i will try this out.

Any other suggestions or more professional approaches?