Search results

Hi Mike, I have tryed your suggestion a few different ways but still no success. Could I send you a copy of the database for you to look at or could you send me a copy of your previous project. Thanks again for your continued support. Jerry

I think your on the right track but here is some more detail. The form starts with so information about the movement of a truck and it's cargo. We then move into this Status-Code Subform to record it's status ie: X3 stands for truck arrival for pickup CP stands for pickup complete X1 stands...

Good Morning, I am attempting to prevent a duplicate value being entered in my Status-Code subform. There are 5 possible choices from a combo box named StatusCode. I would like either a msgbox announcing that it is a duplicate value or a cancel event to disallow the selection. Can you please...

Thank You for the response. Could you help me with the coding for this dmax function as I can't seem to get it right. Keep in mind that this is a date field. Thanks Again JerryJ

I am still hoping for some help on my validation problem. 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...

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

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...