Check two values
Posted on 2013-12-30
I use Access 2010.
I need to make a label and image visible on a form if there are values in two specific fields within two separate tables. If there are no values then the label and image will be invisible.
Basically the two fields are 'ContactID' and 'Complete'. The ContactID is a text field and the 'Complete' field is a Yes/No field.
I have two forms - 'Form1' and 'Form2'.
In 'Form 1' I have two fields. 'ContactID' and 'Complete'. I also have these fields in 'Form 2'.
When I open 'Form 1' I want to check if there's another 'ContactID' with the same ID in form2 and if it has the field 'Complete' ticked. If it does, then it will display the label and img to show it's complete. If it can't find the same 'ContactID' and the field 'Complete' isn't ticked, then it will not display the label and img.
Thanks for your help.