Unanswered: Using Screen.PreviousControl.SetFocus how I get the value in the Control.!!!!!
I have disabled a Default Filter buttons in my
Access97 Form and instead have a command button that
when clicked Filters the form. I am using the
following to filter in the Click event of the command
Now my problem is I also want to get the current
selected value of the control and run a SQL Query
according to that value also i.e. after
I want to get the value of that control also and store
it somewhere. Currently I have lot of different
controls on the Form CheckBoxes, ComboBoxes, TextBoxes
etc. Means when I
on the previous control is there any way I get the
current value shown in the control also and then after
that execute my
Thanks for any help.