All,
My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testat ors"
The object name of instance 1 of the form is "SFRM_Clien ts".
The object name of instance 2 of the form is "SFRM_Mirro rs".
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_Relation ships, 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
3  1530 
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_Relation ships include a Gender field to aid in specific
mirror assignment?
hth
"Patrick A" <pa*****@stradl ey.comwrote in message
news:11******** *************@n 39g2000hsh.goog legroups.com...
All,
My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testat ors"
The object name of instance 1 of the form is "SFRM_Clien ts".
The object name of instance 2 of the form is "SFRM_Mirro rs".
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_Relation ships, 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,
In this case, it is simpler than that. The clients and mirrors are
spouses. In the event that my "Relationsh ips" 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_Relation ships include a Gender field to aid in specific
mirror assignment?
hth
"Patrick A" <park...@stradl ey.comwrote in message
news:11******** *************@n 39g2000hsh.goog legroups.com...
All,
My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testat ors"
The object name of instance 1 of the form is "SFRM_Clien ts".
The object name of instance 2 of the form is "SFRM_Mirro rs".
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_Relation ships, 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
Clarifications inside < >'s
All,
My form "FRM_Main" contains 2 subforms, each an instance of the form
"FRM_Testat ors"
The object name of instance 1 of the form is "SFRM_Clien ts".
The object name of instance 2 of the form is "SFRM_Mirro rs".
<<
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_Relation ships, 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: CSDunn |
last post by:
Hello,
I have an Access 2000 ADP main form called frmAD_OpeningForm that
needs to support several possible sub forms.
The subform that should appear would be based on the combined bound
values of two combo boxes that are located in the form header of the
main form. The way I have the combo boxes set up in the main form is
to have the user make a selection in each combo box, then click a
button named ‘Set' (and labeled ‘Set') to make the...
|
by: Paul T. RONG |
last post by:
Is it possible to divide a tall subform with 80 records to two subforms each
with 40 records?
Dear All,
What I have: Tables: tblProduct, tblOrder, tblOrderDetail
|
by: thx606 |
last post by:
Hello,
I'm having problems figuring this one out. I have 2 combo boxes. The
first one the user selects a professor then the second one they select
a course and that works fine. Here is my problem for a third field used
for mailing instructions. I would like to look this up in a seperate
table based off the values entered in the combo boxes. So, if
professor and Course match then that mailing instructon would appear in
the third field....
|
by: Richard Stanton |
last post by:
Hello all
My database has a main form linked to table1. It has several subforms
on the main form, all linked to table2. Table1 and Table2 are linked
by primary/foreign key, no duplicates allowed, one-to-one.
If I update field(s) on a single subform it works fine but when I
update fields on multiple subforms ie without closing the form between
updates, I get the following error:
|
by: Zlatko Matiæ |
last post by:
Hello.
How can I synchronize subforms content with current record in master form,
if both form and subform are based on DAO code ?
I assigned DAO recordset to forms by using QueryDef, on Load event.
Thanks...
| | |
by: Ron |
last post by:
Hi All,
Was just wondering which is faster, a subreport or dlookup.
I've got a report with either 5 subreports or lots of dlookups. The
subreports generally have anywhere from 5 to 12 controls on them so if I
don't do the subreport thing, I'm doing TONS of dlookups.
Just wondering what others have found to be a faster way to do things. Is
there even a faster way I'm unaware of yet than these 2 options?
|
by: jonvan20 |
last post by:
I have been having trouble with a simple Dlookup command that was Reccommended to me by a nice fellow named Vic, On the other hand I have statements like this that wont run they give me a run time error
Dim QuoteNumber As String
QuoteNumber = Me.txtQuoteNumber
Me.txtDealerNumber = DLookup("Dealer_Number", "Quote Table", "Quote_Number=" & txtQuoteNumber)
|
by: reginaldmerritt |
last post by:
I'm using Dlookup to search a table for the first record it comes across that has a date >= the date i specifiy.
e.g.
formateddate = format(Me.SelectedDate,"mmddyy")
VarX = DLookup("", "tbChargeRate", " >= #" & formateddate & "#")
The problem i have is that there maybe several records in tbChargeRate that have PKDateField > Me.SelectedDate. But i only want the first one it comes across, which is what i thought DLookup did.It does...
|
by: dkotula |
last post by:
Hello,
I have a DB with linked tables to ODBC, and queries based on them. I have a form with 3 cascading combo boxes and tabs containing subforms. Along with the combo boxes on the main form I have a txtJobNum, and a txtVendorNum. The subforms I have, are Job and Vendor. In subform Job, I have txtJobNum, and in subform Vendor I have txtVendorNum. What I did was use columns from the last combo box to populate txtJobNum and txtVendorNum on the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
