H
hughess7
Hi all
I have a combo on the main form (frmDealerClaimCheck) which is set to Value
List, the Rowsource is set programmatically and contains all field names and
data types from a specific query. There is also an unbound text box on main
form which contains the criteria to filter on. When the user presses a filter
button I want the subform (frmClaims) to filter the records (it shows all
records when first opened) to just the criteria selected in the unbound text
box for the field specified in the combo box.
Can anyone help with the coding please? I have the field name to search in a
field called cboField, the data type of this field is stored in column(1) (eg
Text, Date/Time etc) of this combo box. The criteria to search is in a field
called txtCriteria on the main form.
Hope this makes sense... thanks. Sue
I have a combo on the main form (frmDealerClaimCheck) which is set to Value
List, the Rowsource is set programmatically and contains all field names and
data types from a specific query. There is also an unbound text box on main
form which contains the criteria to filter on. When the user presses a filter
button I want the subform (frmClaims) to filter the records (it shows all
records when first opened) to just the criteria selected in the unbound text
box for the field specified in the combo box.
Can anyone help with the coding please? I have the field name to search in a
field called cboField, the data type of this field is stored in column(1) (eg
Text, Date/Time etc) of this combo box. The criteria to search is in a field
called txtCriteria on the main form.
Hope this makes sense... thanks. Sue