Hello!
I have two tables (a & b). When I enter data in a form (two pieces of information are date and time), after I've entered the date and time in the form which updates table a I want it to check the records in table b for the same date and time, once this record is found there is a field called 'spaces' if this field is = 0 then I want a message box to appear saying "Course Full".......any ideas!! :banghead:
Thanks in advance!!!
I have two tables (a & b). When I enter data in a form (two pieces of information are date and time), after I've entered the date and time in the form which updates table a I want it to check the records in table b for the same date and time, once this record is found there is a field called 'spaces' if this field is = 0 then I want a message box to appear saying "Course Full".......any ideas!! :banghead:
Thanks in advance!!!