Prev: Access 2007: bug? quick filter list is sometimes empty
Next: Destination fields disappear from query used in subform.
From: Tara on 11 Feb 2010 09:25
I would like to change the background of a text box based on whether or not a
corresponding record exists in another table. Is that possible?
From: Marshall Barton on 11 Feb 2010 10:01
Tara wrote:

>I would like to change the background of a text box based on whether or not a
>corresponding record exists in another table. Is that possible?


Probably.

Without any more info than that, all I can say is to try
modifying the form's record source query an outer join to
the other table. Then you can pick up a field from the
other table and test that for Null in Conditional formatting
to display a different color on a text box.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Access 2007: bug? quick filter list is sometimes empty
Next: Destination fields disappear from query used in subform.