validate based on another value

[subnet11]

Hi All,

I Am a new here, so I hope I am posting in the correct section. So here is my question with a little history : I have an Access Database. It has a field Track with 4 possible options (1,2,3,4). So right now when a user is filling in this field it happens that they miss a track. for e.g.
1 = Ordered


2 = Received
3 = Sold
4 = Closed
Sometimes they forget to input the ordered before receiving. So I want to know how I can make a validation rule where 1 has to be done before 2 can be used, and 2 has to be done before 3 can be used etc etc.

Thanks.

[June7]

There is no expression possible for the ValidationRule property. This requires code that will check for data in existing records.

Options:

1. Take the decision away from the user. Automate with code. Code would check database for previous records and determine the appropriate option and inform user.

2. User makes choice and code verifies afterward. If they goofed they get the digital equivalent of slap on the wrist.

[subnet11]

Hi,

How do I implement option 1. Sorry I am learning access.

Thanks.

[June7]

I don't know your data, forms, or business flow so can't be specific. It sounds like each option will have its own record. So does user click a button on one form (a menu?) to open the 'tracking' form? When does user select the customer and order this new 'tracking' record will be entered for? Perhaps code in the event for selecting the customer order can check the tracking table to find the last record for that customer and order and what option is in that record, if no records found then must be entering first option. A DMax function is a possible method.

How much programming skill do you have? Review: http://office.microsoft.com/en-us/ac...010341717.aspx