Windows 7 
Access 2010 (version 14.0)
Hello all,
I have an issue that is driving me CRAZY and hopefully someone can help.
Please forgive my length here but it will save back and forth clarification
So, I have this database that opens to a main form.
On the left is a box with several selection buttons (this takes up roughly 25% of total form area) and then a subform takes up the remaining 75%.
The name of the subform is: Switchboard_Subform
And the Source Object is: Frm_Switchboard_Main
Frm_Switchboard_Main is essentially an empty form, a blank placeholder with a Logo.
When the user clicks on one of the selection buttons it loads that form into the subform Switchboard_Subform.
Here is the code behind that:
Private Sub Command5_Click()
Me!Switchboard_Subform.SourceObject = "FRM_CREATE_DRV_PRF"
End Sub
The form FRM_CREATE_DRV_PRF is loaded in.
So far, so good.
No issues.
Here is the issue:
I have another form that is loaded just like the one described above, it is called:
SUB_DRVPRF_SRCH.
It is a date range search for that will populate a continuous form with data once the dates are selected.
On this form (actually the query behind it) is a date field named ModDate for Modified date.
In order to capture the dates for the search this is what I have built into the query in the criteria for ModDate.
Between [Forms].[SUB_DRVPRF_SRCH].[BeginDate] And [Forms].[SUB_DRVPRF_SRCH].[EndDate]
This works PERFECTLY but ONLY if I make this Form a pop-up.
The minute I try and load this in to the Switchboard_Subform I get the following pop up messages:
Enter Parameter Value
Forms.SUB_DRVPRF_SRCH.BeginDate
(Enter or Cancel) then
Enter Parameter Value
Forms.SUB_DRVPRF_SRCH.EndDate
Here is one I have tried to no avail
Between Me.Forms.Switchboard_Subform.Form.BeginDate And Me.Forms.Switchboard_Subform.Form.BeginDate
Actually I have tried several more but my brain is fried so any idea how I can get this to work INSIDE the subform or do I have to make it and pop up?
Reply With Quote
