R
RichardY
In an earlier post I figured out how to permanently sort my date colum
(in my subform) in ascending order by pointing it to a query. However
by doing this my validation rule, which I had setup for one of th
fields, no longer works.
Originally, my subform was pointed to a subform in the Forms Windo
where I set up a validation rule that the "Return Date" field had to b
greater than or equal to the "Sign-Out Date" field. When I pointed th
subform to the query, so that I can permanently sort my "Sign-Out Date
field in ascending order, I couldn't retain the validation rule.
Is there a way where I can get the best of both worlds here? Pleas
help
(in my subform) in ascending order by pointing it to a query. However
by doing this my validation rule, which I had setup for one of th
fields, no longer works.
Originally, my subform was pointed to a subform in the Forms Windo
where I set up a validation rule that the "Return Date" field had to b
greater than or equal to the "Sign-Out Date" field. When I pointed th
subform to the query, so that I can permanently sort my "Sign-Out Date
field in ascending order, I couldn't retain the validation rule.
Is there a way where I can get the best of both worlds here? Pleas
help