Validation Rule - Access Form

[JezBullen]

Hi,

Probably a very common/simple question but I'm trying to validate the entry of a Text Box from a Form. The data input must be on another table (Customers) to ensure the correct information is entered

I've tried various Validation Rules, but with no luck

I had thought the followinf would have worked, but it didn't

In ([Customers].[Keycode])

Hope someone can help
Jez

 

[mp9]

Have you established a relationship between these two fields and ensured referential integrity? This would take care of the validation for you.

http://www22.brinkster.com/accessory/

 

[JezBullen]

Thanks, that worked fine

Cheers