Hello All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I have an unbound form with some combo boxes and I also have a subform which shows around 88000 records, what I would like to do is select a year from the combo box and it filters the subform content. My concern is the combo box uses numeric numbers from a table but the subform has the year as a text field.<o></o>
<o> </o>
Their names as follows:<o></o>
<o> </o>
The combo box is called cboUnderwritingYear<o></o>
The subform name is frmCombinedSearchEngine<o></o>
The subform also sits inside a child facility called child27<o></o>
<o> </o>
I have been trying to work with the following code but it fails each time.<o></o>
<o> </o>
Me.frmCombinedSearchEngine.Form.Filter = "[Underwriting Year]=" & Chr(34) & Me.cboUnderwritingYear & Chr(34)<o></o>
me.frmCombinedSearchEngine.Form.FilterOn = True<o></o>
<o> </o>
I also tried setting the combo box as the criteria in the query but when I open the form before selecting anything my records are reduced to around 33000<o></o>
<o> </o>
Any guidance would be very much appreciated. <o></o>
<o> </o>
I have an unbound form with some combo boxes and I also have a subform which shows around 88000 records, what I would like to do is select a year from the combo box and it filters the subform content. My concern is the combo box uses numeric numbers from a table but the subform has the year as a text field.<o></o>
<o> </o>
Their names as follows:<o></o>
<o> </o>
The combo box is called cboUnderwritingYear<o></o>
The subform name is frmCombinedSearchEngine<o></o>
The subform also sits inside a child facility called child27<o></o>
<o> </o>
I have been trying to work with the following code but it fails each time.<o></o>
<o> </o>
Me.frmCombinedSearchEngine.Form.Filter = "[Underwriting Year]=" & Chr(34) & Me.cboUnderwritingYear & Chr(34)<o></o>
me.frmCombinedSearchEngine.Form.FilterOn = True<o></o>
<o> </o>
I also tried setting the combo box as the criteria in the query but when I open the form before selecting anything my records are reduced to around 33000<o></o>
<o> </o>
Any guidance would be very much appreciated. <o></o>