A subform on an Access2000 database gets its data from a Select query whose datasource is a table in an AS400 database.
Without any criteria in the query all the records display in the subform.
The Access main form also has a textbox that carried a date value passed to it from a calendar control also on the main form. Now if the query is modified to include as a criteria a reference to the textbox: [Forms]![myForm]![myTextbox] no records are displayed even when the textbox date matches the date field in the data table. The date field in the table which is being compared to the textbox on the form is a TEXT type not a DATE type.
However when this process is tested against an apparently identical table within the Access database it works fine whether or not the Date field is date or text type.
Can anyone tell me whether the Access/AS400 connection requires that the query criteria's reference to the textbox object should be written differently?
Rod
Without any criteria in the query all the records display in the subform.
The Access main form also has a textbox that carried a date value passed to it from a calendar control also on the main form. Now if the query is modified to include as a criteria a reference to the textbox: [Forms]![myForm]![myTextbox] no records are displayed even when the textbox date matches the date field in the data table. The date field in the table which is being compared to the textbox on the form is a TEXT type not a DATE type.
However when this process is tested against an apparently identical table within the Access database it works fine whether or not the Date field is date or text type.
Can anyone tell me whether the Access/AS400 connection requires that the query criteria's reference to the textbox object should be written differently?
Rod