Checking for Errors

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!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200609/1

You might be able to do this without VBA. Look at the Validation Rule
property for the Date textbox. You can put any function you like in the
property, including DLookup. The only trick is getting the criteria statement
for dlookup correct. Without knowing your field names/types, it's difficult
for us to help you build it.

Barry

"taylor via AccessMonster.com" wrote:

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!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200609/1