T
taylor via AccessMonster.com
Hi
Pleeease help!
i have a table called Teaching_Subject. It is made up of details regarding
the subject e.g. teacher name etc and a subform. the subform is called
Teaching_measure. It shows the dates to and from that the subject is being
taught.
On another form, teaching_options - the user is required to enter a Date and
select a Teaching Subject (this is a combo box - coming from teaching_subject)
what i'd like is for their to be 'check' that see's whether the date the
user has entered in teaching_options is BEFORE the date in Teaching_Measure.
The flow of events is -
teaching_measure -> teaching_subject -> teaching_options
i know this information is v.basic but can anyone tell me what is the best
way to carry out this validation? e.g. creating a funtion in a module?
dlookup? im so stuck!
Pleeease help!
i have a table called Teaching_Subject. It is made up of details regarding
the subject e.g. teacher name etc and a subform. the subform is called
Teaching_measure. It shows the dates to and from that the subject is being
taught.
On another form, teaching_options - the user is required to enter a Date and
select a Teaching Subject (this is a combo box - coming from teaching_subject)
what i'd like is for their to be 'check' that see's whether the date the
user has entered in teaching_options is BEFORE the date in Teaching_Measure.
The flow of events is -
teaching_measure -> teaching_subject -> teaching_options
i know this information is v.basic but can anyone tell me what is the best
way to carry out this validation? e.g. creating a funtion in a module?
dlookup? im so stuck!