Is a DLookup Across Schizophrenic Subforms Possible?

[Patrick A]

All,

My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testators"
The object name of instance 1 of the form is "SFRM_Clients".
The object name of instance 2 of the form is "SFRM_Mirrors".

The form contains (among others) the combo boxes "Rel2Client" and
"Rel2Mir". (Indicating the relationship between the client and the
mirror.

I have a lookup table named LU_TBL_Relationships, which contains the
column "REL" with all possible relationships (husband, wife, father,
mother, etc.) and the column "MIR" with all of the possible "mirrors"
of those relationships (wife, husband, father-in-law, mother-in law,
etc.).

Currently, I have code in FRM_Main that sets the combo box
"Rel2Client" to "invisible" on SFRM_Clients and the combo box
"Rel2Mir" to "invisible" on SFRM_Mirrors.

Is there a way, once the user sets the value of the combo box
"Rel2Mir" on SFRM_Clients, I can have a DLookup set the value of
"Rel2Client" on SFRM_Mirrors = to the "mirror" value in the LU table?

I've tried a number of code strings, and don't know if I'm fighting
syntax or trying to do something that can't be done....

Any guidance would be appreciated.

Thanks,

Patrick

[tina]

is it really that simple? what about client as father-in-law - the mirror
could be son-in-law OR daughter-in-law, correct? ditto client as
mother-in-law. and conversely, client as son-in-law could be mirrored by
father- or mother-in-law. and the direct relationships are ambiguous too:
father/son-or-daughter, mother/son-or-daughter, son/father-or-mother,
daughter/father-or-mother.

does your LU_TBL_Relationships include a Gender field to aid in specific
mirror assignment?

hth
"Patrick A" <pa*****@stradley.comwrote in message
news:11*********************@n39g2000hsh.googlegro ups.com...

All,

My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testators"
The object name of instance 1 of the form is "SFRM_Clients".
The object name of instance 2 of the form is "SFRM_Mirrors".

The form contains (among others) the combo boxes "Rel2Client" and
"Rel2Mir". (Indicating the relationship between the client and the
mirror.

I have a lookup table named LU_TBL_Relationships, which contains the
column "REL" with all possible relationships (husband, wife, father,
mother, etc.) and the column "MIR" with all of the possible "mirrors"
of those relationships (wife, husband, father-in-law, mother-in law,
etc.).

Currently, I have code in FRM_Main that sets the combo box
"Rel2Client" to "invisible" on SFRM_Clients and the combo box
"Rel2Mir" to "invisible" on SFRM_Mirrors.

Is there a way, once the user sets the value of the combo box
"Rel2Mir" on SFRM_Clients, I can have a DLookup set the value of
"Rel2Client" on SFRM_Mirrors = to the "mirror" value in the LU table?

I've tried a number of code strings, and don't know if I'm fighting
syntax or trying to do something that can't be done....

Any guidance would be appreciated.

Thanks,

Patrick

[Patrick A]

Tina,

In this case, it is simpler than that. The clients and mirrors are
spouses. In the event that my "Relationships" table does not provide
the answer, the user will be able to provide the correct answer.

So I am back to trying to figure out if the DLookup I am trying to do
is possible.

Can anyone provide any guidance on syntax, if so?

Thanks,

Patrick
On Sep 22, 12:43 am, "tina" <[e-mail]:

is it really that simple? what about client as father-in-law - the mirror
could be son-in-law OR daughter-in-law, correct? ditto client as
mother-in-law. and conversely, client as son-in-law could be mirrored by
father- or mother-in-law. and the direct relationships are ambiguous too:
father/son-or-daughter, mother/son-or-daughter, son/father-or-mother,
daughter/father-or-mother.

does your LU_TBL_Relationships include a Gender field to aid in specific
mirror assignment?

hth

"Patrick A" <[e-mail] in message

news:11*********************@n39g2000hsh.googlegro ups.com...

All,

My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testators"
The object name of instance 1 of the form is "SFRM_Clients".
The object name of instance 2 of the form is "SFRM_Mirrors".

The form contains (among others) the combo boxes "Rel2Client" and
"Rel2Mir". (Indicating the relationship between the client and the
mirror.

I have a lookup table named LU_TBL_Relationships, which contains the
column "REL" with all possible relationships (husband, wife, father,
mother, etc.) and the column "MIR" with all of the possible "mirrors"
of those relationships (wife, husband, father-in-law, mother-in law,
etc.).

Currently, I have code in FRM_Main that sets the combo box
"Rel2Client" to "invisible" on SFRM_Clients and the combo box
"Rel2Mir" to "invisible" on SFRM_Mirrors.

Is there a way, once the user sets the value of the combo box
"Rel2Mir" on SFRM_Clients, I can have a DLookup set the value of
"Rel2Client" on SFRM_Mirrors = to the "mirror" value in the LU table?

I've tried a number of code strings, and don't know if I'm fighting
syntax or trying to do something that can't be done....

Any guidance would be appreciated.

Thanks,

Patrick

[Patrick A]

Clarifications inside < >'s

All,

My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testators"
The object name of instance 1 of the form is "SFRM_Clients".
The object name of instance 2 of the form is "SFRM_Mirrors".

<<
Here's a crude example of the layout
Person - SFRM_Clients - SFRM_Mirrors
Bob - Father------------ Father-in-Law
Janet - Mother------------ Mother-in-Law

>>

The SFRM forms contain (among others) the combo boxes "Rel2Client" and
"Rel2Mir". (Indicating the relationship between the <PERSON
CONCERNED>and the Client and the <PERSON CONCERNEDand the mirror.
I have a lookup table named LU_TBL_Relationships, which contains the
column "REL" with all possible relationships (husband, wife, father,
mother, etc.) and the column "MIR" with all of the possible "mirrors"
of those relationships (wife, husband, father-in-law, mother-in law,
etc.).

Currently, I have code in FRM_Main that sets the combo box
"Rel2Client" to "invisible" on SFRM_Clients and the combo box
"Rel2Mir" to "invisible" on SFRM_Mirrors.

Is there a way, once the user sets the value of the combo box
"Rel2Mir" on SFRM_Clients, I can have a DLookup set the value of
"Rel2Client" on SFRM_Mirrors = to the "mirror" value in the LU table?

I've tried a number of code strings, and don't know if I'm fighting
syntax or trying to do something that can't be done....

Any guidance would be appreciated.

Thanks,

Patrick