Data Validation of another field

[dssrun]

I am trying to make a data validation rule of Field1 equal to Field2 (sounds silly but I need to make sure the data I am importing has no errors in the source data).

I tried the data validation rule in Field1 "= Field2" but it did not work. Is this possible to do? Thanks.

[ajetrumpet]

I don't think it should be done in access. thinking about it, if you set a rule like that at a table level, then import data that violates it, you're gonna see this:

'X' records were not imported due to validation errors

Hence, doing this is probably irrelevant if you want all data from your source.

If you want no import errors or extra work to do when validation errors occur on import, why not validate the data in the source before it comes in?

[dssrun]

I wanted to create this to remind to me check because last time I forgot. When there is a field1 value there should be a field2 value however this depends on other parameters the end user might miss and therefore that system might not show a field2 value. I want to catch these small mistakes on my end and remind me at the same time. 99% of the time there is a field1 and field2 value.

I guess i can always go to VBA to check the table, i just thought there was an easier way in table properties.

[ajetrumpet]

again, I'm pretty sure the import will error if you DO figure out how to do it. Why don't you just write a small procedure in vba to run after the import. say something like:

docmd.runsql "update table set [field1] = [field2] where [field1] is null"

[dssrun]

ya that is a good plan and that is easy enough to create and setup. Thanks.