Please help with my MACRO problem

[archiwill]

Hi everyone,
thanks for having a look at my problem. This is my first post so I hope I'm clear in explaining this.

I have 2 tables and a form.
Table1 = master
Table2 = subtable

There are 3 parts to this;
1.
I want to compare two fields to automatically input into a third field.
For example if FIELD A = FIELD B(+/-1), then FIELD C 'yes', 'no'

2.
There are 16 rows in which I would like this to work.
If 5 or more of these rows have 'no' in FIELD C, then I would like that the 'no' entries are highlighted red.



3.
FIELD B is a list of entries in Table2 and at the moment I am only able to see them on the form (and in Table2). Do I need to find a way to autopoulate the selected entry into the Table1 entry for this comparison or can I do it with the FIELD B info on in Table2?
The entries in Table2 can relate one-to-many.

I've been looking for a wee while for ways to do this and haven't gotten very far. I've been looking at writing a Macro to do this. I think this is the best way? I found something online about using SETFIELD but the option doesn't come up on my computer.

Thanks for taking the time

Will

[June7]

1. Saving data dependent on other data is usually a bad idea. Calculate the value when needed. This can be in a query or in textbox on form or report.

2. What do you mean there are 16 rows? Why are there only 16 rows?
Use textbox ConditionalFormatting on form or report.

3. FIELD A and FIELD B are both in subform?

Want to provide db for analysis? Follow instructions at bottom of my post.