C
Chester1
I have a combo box field called Test Type for Primer and Exam purposes
The fieLd holds the following data (sample) WP PRIMER WP EXAM SS PRIMER SS
EXAM PP PRIMER PP EXAM when I have selected a tes type and move to the next
field called Test Date I want the macro to check what has been put in to the
previous field and if it contains the word exams then to pick the list of
dates in a query called exam dates but if the field contains the word primer
then use the query called primer dates. I hope this makes sense I have
managed to do it but only using the word Primer and Exam not with the
initials of the Application
If someone can help pleas could you explain it step by step as I am a novice
at this and self taught.
Reghards Clair
The fieLd holds the following data (sample) WP PRIMER WP EXAM SS PRIMER SS
EXAM PP PRIMER PP EXAM when I have selected a tes type and move to the next
field called Test Date I want the macro to check what has been put in to the
previous field and if it contains the word exams then to pick the list of
dates in a query called exam dates but if the field contains the word primer
then use the query called primer dates. I hope this makes sense I have
managed to do it but only using the word Primer and Exam not with the
initials of the Application
If someone can help pleas could you explain it step by step as I am a novice
at this and self taught.
Reghards Clair