-
On most of my projects that are database related, I have used the data control and a data grid. I simply needed to place the data control on the form, set its data source and record source and then link the grid to the data control by setting it as the source. Then as I clicked on the move next, move last, move previous and move first arrows on the data control I could see the grid current record in the grid move accordingly.
However, if I try to use MSFlexGrid or MSHFlexGrid and trhe appropriate data control for the respextive grids, the grid reflexts the data (ie. fills with the proper records) but I cannot get the grid to follow as I step through the database using the data control's arrow keys.
What am I doing wrong?
On an unrelated matter, I have another project that displays fields on a form from several different tables from the same database. What I want to do is place three data controls on the form (two of which, will not be visable) and connect the appropriate fields(controls that display the fields) to the appropriate data control. This works fine. What I would like to know is how I can keep these controls in sync. I want to click on the visable control and have all three controls respond accordingly. For instance if I move to the 5th record with the visable data control, the other two would do the same, thus allowing all the controls (ie. Text bowes, combobxes, etc) to display the appropriate data.
Thanks for your assistance and patience,
Rev. Michael L. Burns
-
Re: your 3 data controls
It may be easier to use just one data control, and for it's recordsource use a JOIN query
-
Jimbob,
I never gave that a thought. I'll give that a try.
Pastor Mike
