Validate form data fields based on other fields within the form?

[Compass]

First post, so be gentle with me, apologies if this is old ground.



I am using a form to allow some staff to input data for me, the form includes various drop down menus including a "PART NUMBER" field.

I've added a "#MISSING#" option in the "PART NUMBER" drop down menu because sometimes the part numbers haven't been populated into the list. I also have an "INFO" field for general text etc to be added in the form.

I would like to force the arguement that if the "PART NUMBER" field shows "#MISSING#" then the "INFO" field must NOT be empty and generate a reminder for them to add the required part numbers into the "INFO" field so that i can review and update.

I no that there are more inteligent ways of using Access and getting the part number field to lookup from a sperate ODBC link to our MRP/ERP software etc would be a better method but you have to work with what you've got.....and this is what I've got.

Any help appreaiacted, thanks.

[RuralGuy]

Do you force the user to complete the "INFO" field before selecting the "PART NUMBER"? If so then you can take care of this in the AfterUpdate event of the PartNumber ComboBox.

[Compass]

No, the "INFO" field is my only open field at the moment because they don't always need to add anything here (I had to add a validation rule for all my other fields to ensure no empty boxes because I was getting more blanks than actual data!)

The INFO field may or may not need completing but I want to specifically ask for the #MISSING# info to be added in the INFO field if selected from the list of part numbers.

[RuralGuy]

You can enforce that rule in the BeforeUpdate event of the form.

[Compass]

You can enforce that rule in the BeforeUpdate event of the form.

#

I'll look into it, if I get stuck I'll come back to the forum, cheers.

[RuralGuy]

We'll be here.