JustAnotherPar
IS-IT--Management
Here's my challenge: Display a subset of data in a subform, in DataSheet format (so header-widths can be adjusted & used to sort columns with), based on a value entered into a textbox on the Master form. Unfortunately it has to be done in Access97.
What I've done so far: From a Master form I write a value to a global variable, then, using that value as a parameter in an SQL statement, write the SQL string to the subform's RecordSource Property. I can't get the subform to refresh from within the Master form with the runtime SQL statement.
I've tried to find a DataGrid control that's free and works with Acces97. I tried to load one from Access2000 or VB, registered the control and all, but Access97 wouldn't have any of it. Maybe someone can help this way.
I know it is partially working, because I can open the subform by itself and it will read the global variable, run an Open Event and display the correct subset. I have tried the RecordSource code in the Master form, on several of the subform's events, I have used .Refresh, .Repaint, SetFocus and other Event controls, but can not get the forms to cooperate. Hopefully, someone has been down this road before and it is an easy path.
Thanks in advance.
What I've done so far: From a Master form I write a value to a global variable, then, using that value as a parameter in an SQL statement, write the SQL string to the subform's RecordSource Property. I can't get the subform to refresh from within the Master form with the runtime SQL statement.
I've tried to find a DataGrid control that's free and works with Acces97. I tried to load one from Access2000 or VB, registered the control and all, but Access97 wouldn't have any of it. Maybe someone can help this way.
I know it is partially working, because I can open the subform by itself and it will read the global variable, run an Open Event and display the correct subset. I have tried the RecordSource code in the Master form, on several of the subform's events, I have used .Refresh, .Repaint, SetFocus and other Event controls, but can not get the forms to cooperate. Hopefully, someone has been down this road before and it is an easy path.
Thanks in advance.
