Comparing Forms for Matching Data

How can I make my main form (Orders Processing) look for matching SSNs in
another form (DEROG 06) and change the SSN in the main form to "Red" to
indicated that SSN is located in the DEROG 06 form? (Each record has a SSN
that may or may not be in DEROG 06 form.)

Thanks in advance.
--

So the record is straight, forms do not *contain* data, tables do. Having
said that, you could use a DLookup() in the Current event of your form to
compare the SSN and set the control to red if it matches. It would actually
be faster to use a recordset of the other table and a FindFirst, but I'll
leave that up to you.

rshed wrote:
How can I make my main form (Orders Processing) look for matching SSNs in
another form (DEROG 06) and change the SSN in the main form to "Red" to
indicated that SSN is located in the DEROG 06 form? (Each record has a SSN
that may or may not be in DEROG 06 form.)

Thanks in advance.
--

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

I noticed you answered one of my other question. I failed to mention that
I'm pretty new at this and learning more as I go. Orders Processing and
DEROG 06 are Tables which I'm trying to compare SSNs with the results
reflected in my main form which is also called "Orders Processing." I tried
the DLookup to no avail. Please give me the information I need to type. I
seem to understand it better when I can relate it to my database.

Again, Thanks in advance.
--



"ruralguy via AccessMonster.com" wrote:

So the record is straight, forms do not *contain* data, tables do. Having
said that, you could use a DLookup() in the Current event of your form to
compare the SSN and set the control to red if it matches. It would actually
be faster to use a recordset of the other table and a FindFirst, but I'll
leave that up to you.

rshed wrote:
How can I make my main form (Orders Processing) look for matching SSNs in
another form (DEROG 06) and change the SSN in the main form to "Red" to
indicated that SSN is located in the DEROG 06 form? (Each record has a SSN
that may or may not be in DEROG 06 form.)

Thanks in advance.
--

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

Hi rshed,
How about posting the DLookup() code you wrote and we can offer suggestions
on how to change it.

rshed wrote:
I noticed you answered one of my other question. I failed to mention that
I'm pretty new at this and learning more as I go. Orders Processing and
DEROG 06 are Tables which I'm trying to compare SSNs with the results
reflected in my main form which is also called "Orders Processing." I tried
the DLookup to no avail. Please give me the information I need to type. I
seem to understand it better when I can relate it to my database.

Again, Thanks in advance.
So the record is straight, forms do not *contain* data, tables do. Having
said that, you could use a DLookup() in the Current event of your form to
[quoted text clipped - 9 lines]
Thanks in advance.
--

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1