Allowing the User to select any date that is not contained in a table

[Dylan Snyder]

Okay, here goes:
This is a Puchase order change request form whereby the User can change select a PO and change marka new date for the PO. This gets recorded to a table called PO change request. The PO can be changed multiple times before it is shipped. Each individaul request is copied and kept in the table. What I want is for the user to be able to select any date except for the dates that the PO has already been changed to. Thus, the PO # and Date requested need to be unique. Due to another issue, I cannot set the PK to PO and New Date Requested. I have tried some tricks, but cannot get anything to work. Any suggestions. I've tried to give as much info as I can, but if you can think of anythuing else I need to add, please let meknow. Thanks in advance.

 

[wazz]

how bout setting the current date/time? the current time will always be after the last. user doesn't necessarily have to see the time, but it could be useful.

 

[Dylan Snyder]

Thanks, What I figured out was I could have the date field as a not in list disallowed combo box and run it off of a query that did not include previously requested dates. Not ideal, but it works and is better than spending time trying to figure it out when there may not be a way to do it.