inspector-71
New member
- Local time
- Today, 15:06
- Joined
- Jun 2, 2010
- Messages
- 9
I have two tables called [ncr table] and [actions]. These have a relationship defined by [ncr code]
I have a form open, also called [ncr table] which I have got a text box on which I have set up with condintional formatting.
What i want to do is for this text box to chage colour if my record from the table [NCR table] which is shown in the continuous form [NCR table] has any associated records in the [actions] table (or even better is there is anything in the [action description] field in the [actions] table.
Hope this makes sense, thanks for the help.
I have a form open, also called [ncr table] which I have got a text box on which I have set up with condintional formatting.
What i want to do is for this text box to chage colour if my record from the table [NCR table] which is shown in the continuous form [NCR table] has any associated records in the [actions] table (or even better is there is anything in the [action description] field in the [actions] table.
Hope this makes sense, thanks for the help.