I have a combo box (cboStudyCode) in a subform (named ProductionSubform)that runs off of a query. The Query has two fields JobNumber and Study Code
The criteria for this query is taken from the input of a text box (txtJobNumber) on the same form.
[Forms]![ProductionSubform]![txtJobNumber]
The combo box is updated whenever the txtJobNumber field is changed using the following code
Private Sub txtJobNumber_LostFocus()
DoCmd.Requery "cboStudyCode"
End Sub
This works perfectly when this form is used as a stand alone form, however when this is used as a subform I get the following error
Runtime Error '2488':
You cannot use the ApplyFilter action on this window.
Can someone please tell me how I can use this correctly as a subform.
Kevin M. Douglas
kevin@easternresearch.com
The criteria for this query is taken from the input of a text box (txtJobNumber) on the same form.
[Forms]![ProductionSubform]![txtJobNumber]
The combo box is updated whenever the txtJobNumber field is changed using the following code
Private Sub txtJobNumber_LostFocus()
DoCmd.Requery "cboStudyCode"
End Sub
This works perfectly when this form is used as a stand alone form, however when this is used as a subform I get the following error
Runtime Error '2488':
You cannot use the ApplyFilter action on this window.
Can someone please tell me how I can use this correctly as a subform.
Kevin M. Douglas
kevin@easternresearch.com
