Hey all,



I am kinda new to the world of access and was wondering if anyone could help me out. I need to validate a form field on a subform which populates through a query. It basically is a check in and check out field which has a date assigned to it. It is for a study hall database. I am trying to prevent the user from inputing time ranges that overlap for the same day. I.E. I do not want the user to be able to go from 10 am - 11 am, and then have an input again from 10:15 am - 11 am. We have our users manually input the check in and out times, so sometimes they mess up and input overlapping values, giving students the credit for hours they did not really do. Any help would be appreciated, thanks.