Conditional Formatting - Comparing field on form to field on a different table

J

Jay

I have [form1] linked to [table1] which has field [address]

I would like to conditional format field [name] (on [form1])
if [form1]![address] matches any [address] field in [table1]

I tried using Dlookup in the condition field but couldn't get it work.

TIA,
J
 
L

Linq Adams via AccessMonster.com

If you have a field or control designated NAME you have to change this! NAME
is a Reserved Word in Access VBA and using it will cause you major problems,
sooner or later!

As to your question, is Form1 in Single, Continuous or Datasheet View?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicating data to a different table 8
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
iif exists - too complex? 0
How to have two tables on same line? 1
Can results of a Form be exported to a table on another database 0
same data(table) to be display 2 diffrent form 1
Dynamic Naming of Form Button 3
calculated field in form - to table 2

Top