469,604 Members | 2,381 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,604 developers. It's quick & easy.

Is a DLookup Across Schizophrenic Subforms Possible?

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

Sep 21 '07 #1
3 1415
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

Sep 22 '07 #2
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" <nos...@address.comwrote:
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" <park...@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

Sep 23 '07 #3
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

Sep 25 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by CSDunn | last post: by
4 posts views Thread by thx606 | last post: by
5 posts views Thread by Richard Stanton | last post: by
8 posts views Thread by Zlatko Matić | last post: by
6 posts views Thread by Ron | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.