Date in the current record not to be less than date in previous record 1

[Sanasta]

Hi,
I have form based on table.
There is a field Inv_Date which value must be greater than or equal to the previous record value (not less). How to prevent entering (or in case of copy-paste) earlier date for the next invoice?
May be this is easy but I can't do it.
Shall appreciate any help.
Thanks in advance
Sanasta

 

[abaldwin]

The term "previous record" in a rdms is really quite ambiguous. Data is stored in a table but can be retrieved and presented in multiple ways. Best practice is to not use the table as the final guide for outputs, but to use queries with sorting to analyze and manipulate data.

If you are wanting to insure the current date entered is >= to the max date in the current database then you need to look at the

dmax, dlookup functions, or a sql query to retrieve the max date from your table, targeting your date field.

If you can not figure it out with the functions above, then please post what you get to and someone will be more than happy to help you along the way.

Thanks


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.