I'm a novice Access user, so pardon me if some of the terms I refer to is not precise...
This should be pretty simple for some of you advanced users - I have a form that contains a combo box which is bound to a table. When a certain record is selected (in the combo box), I want to feed that record to the criteria of another query. For example:
The table (tblDates)contains that dates
6/15/2002
7/1/2002
7/15/2002
8/1/2002
...
...
These records are bounded to a combo box (cmbDates) on a form (frmSwitchBoard). When 7/15/2002 is selected (in the combo box), I want the criteria of a field of another query (qryTemp) to be >7/15/2002...
Does anyone know how to feed this information to there??
Any help is great.
Janice
This should be pretty simple for some of you advanced users - I have a form that contains a combo box which is bound to a table. When a certain record is selected (in the combo box), I want to feed that record to the criteria of another query. For example:
The table (tblDates)contains that dates
6/15/2002
7/1/2002
7/15/2002
8/1/2002
...
...
These records are bounded to a combo box (cmbDates) on a form (frmSwitchBoard). When 7/15/2002 is selected (in the combo box), I want the criteria of a field of another query (qryTemp) to be >7/15/2002...
Does anyone know how to feed this information to there??
Any help is great.
Janice