I would like to have a form within the main form. This "inside form" should display the contents of two sets of up-to five combo-box set selections. These selections, based on nineteen different tables, will be mirrored in text boxes, from which the code will determine the user's parameters.
My question, then, is: how might I go about displaying the results of those parameters in an interior box? What code should I use? I have the results in a form view, currently, but I'm not certain how it would best look (and tobefrank, those results are not displaying properly).
The code follows, and is also attached in it's entirety, with the Form_run being on page 23.
Thanks in advance for your help.
Private Sub Form_Load()
On Error GoTo Err_Form_Load
Dim strSQL As String, strSQL2 As String, strVariable As String
To clarify in more specific terms, I have the following problem passing information to the query from which this subform is read:
There is a subform window located in the main form (GISTestReporting), which is tied to frmSubOpenQryTrans. A user, through the use of combo boxes, selects a table, then a specific field from that table through which to parse through variables (=, >, <, etc.), and finally an infinite keyword search (text box).
An example is PipelineOne (combo box one) has a feature ReportingType (combo box two) that may equal (variable "=") three ("3" placed in the text box as an infinite keyword). What sort of code would allow the programme to search the specific field noted in it's corresponding table for all incidents equal to 3, and then place the results in qryOpenQryTrans, displayed in the subform window frmSubOpenQryTrans? The code listed above is what I have to define this, but this information is not able to get past the "calculating" stage. Nothing is returned for some reason.
If you can help me with this issue, that would constitute the greatest problem I have with this code, and I would be MOST GRATEFUL!!!!