Good Morning,

I have been pondering this for sometime without the results I need. Therefore I am looking for some help.

The senerio is that on the subform of the main form the data input person selects a code in the first field ( which represents the status of the delivery ie: X3 which stands for Arrival for Pickup) we then tab to the next field which is a date field to record the date of this status code.

When we go to the next record and apply the next status code ie: CP (which stands for Pickup Complete) and tab to the date field we want to insure that the date entered is greater than the previous date of that subform.

I hope this is clear and I thank you in advance for any help you can give.

JerryJ

Your question has been buried in the forms for a couple days. I bet one of the code guys know this.

Somehow you need to validate the control to > the previous control. I played briefly, but all I can do is get a command button to take me back two records!!

Look up the PrevRecVal function.
HTH

Thanks for your reply.

I looked up the PrevRecVal function and as far as I can tell it will copies the previous value forward.

Could you be more specific how I could use it to check the previous control to insure that the value is greater than or equal to it.

Thanks Again

JerryJ