Master link to more than one child - Microsoft Access / VBA

Chewy1026 via AccessMonster.com

Is this even possible. To be able to have a subform where the Master field
on the main form is linked to the subform via 1 child field OR another? So
the table for the main form, can be matched to 2 different fields (one or the
other). Can this be done with only 1 subform?
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200510/1

Nov 13 '05 #1

Subscribe Reply

3766

Larry Linson

"Chewy1026 via AccessMonster.c om" <u8613@uwe> wrote in message
news:5608441cb2 ce4@uwe...

Is this even possible. To be able to have a subform where the Master
field
on the main form is linked to the subform via 1 child field OR another?
So
the table for the main form, can be matched to 2 different fields (one or
the
other). Can this be done with only 1 subform?

As far as I know, the link is limited to the specified Fields and only
those. There can be more than one Field... but not "alternativ e fields".

Depending on exactly what you are trying to accomplish, calculated fields in
the Query that is Record Source of the Form embedded in the Subform Control
_might_ be used to accomplish what you want.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #2

David Lloyd

I agree with Larry. And with the same qualification that, depending on
exactly what you are trying to accomplish, it is possible to
programmaticall y change the Link Master Fields and Link Child Fields
properties. So, if you can find an event to suit your needs, this is
another potential possibility.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Chewy1026 via AccessMonster.c om" <u8613@uwe> wrote in message
news:5608441cb2 ce4@uwe...
Is this even possible. To be able to have a subform where the Master field
on the main form is linked to the subform via 1 child field OR another? So
the table for the main form, can be matched to 2 different fields (one or
the
other). Can this be done with only 1 subform?
--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200510/1

Nov 13 '05 #3

Similar topics

8482

Link Child Link Master Not Working

by: Mark C | last post by:

I have a unbound form with a tab control with four tabs in an Access 97 database. On each tab I have a sub form each form on the sub forms is bound to its own table. Each table has a field that can link them all together. I have put an invisible unbound control on the master form that gets populated on open. I set the link child and link master of each sub form to the unbound control on the master form. When the form opens all the subforms...

Microsoft Access / VBA

1969

asp.net 2.0 master pages problem

by: Martijn Saly | last post by:

Hi there, I've created a master page with some controls on it, a Calendar control among others. Now depending on the date(s) selected, the content page needs to be updated. In the masterpage I've created StartDate and EndDate properties, which are basically wrappers around the SelectedDates property from the Calendar control. When I select another date in the Calendar, the page updates normally, but when Page_Load for the content page...

ASP.NET

1613

Getting Master Page Events From Child Pages

by: gencode | last post by:

I have a logout link in a master page...when the link is pressed I want to capture that event in the child page, not the master page, becase there is some processing I want to do in the child page...is there an easy way to capture the "Handles LinkButtonLogout.Click" from the child page? Thanks, Ed,

ASP.NET

2376

Master Pages and CSS

by: Mikaël PLOUHINEC | last post by:

Hello, I have created a master page with a css. How can I use css in the children pages? The css must be declared in the <head</headsection. Does I have to import all my css in my master? Is there a way to import only one css for one children page? Thanks a lot.

ASP.NET

8301

Access 2000 - Can I not link 1 Master Field to multiple Child Fields???

by: paquer | last post by:

Ok' I have 2 tables. The first being my main table where each record has a 'FigureID' txt box. (Indexed - No duplicates) The second being my sub table where reporting is entered for these Figures. Sometimes more than one at a time. I have 4 'FigureID' txt boxes on this subtable.(All Indexed - Duplicates OK) When I set the Master/Child link for the first FigureID on the Subtable I have no problems.

Microsoft Access / VBA

4548

Searching in detail table to find master record

by: john | last post by:

In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent records. Should I design a new form for this or can I somehow make this work in the same form. Thanks in advance, john

Microsoft Access / VBA

6667

Link Master and Child fields issue

by: imrosie | last post by:

Hello Experts This is a hard one (I still speak newbie). An expert may think it's not a big deal, but, I am trying to replace my Main Order form with a subform because of the following: Original form was based on a query of 2 tables (Order and Customers), the subform was based on table OrderDetail(productname, quantity, discount, unitprice). I was experiencing autonumber problems when attempting to start a new order, because of the inner...

Microsoft Access / VBA

8641

Multiple Link Child and Master Fields

by: Yubin | last post by:

Hello, I'm new to the forums and I wasn't able to find anything in my searches so here we are. I have a DB with a many-2-many relationship. I have a form that has 3 comboboxes: Project #, Last Name, Active(Yes/No) I have a subform that uses Project# as a Child and Master link. I want to use all three exclusively to give the user the option to search using any ONE of the three, but when I add all three to the Child and Master link fields no...

Microsoft Access / VBA

2968

NameError question - def(self,master) - master not in namespacewithin class?

by: harijay | last post by:

Hi I am new to writing module and object oriented python code. I am trying to understand namespaces and classes in python. I have the following test case given in three files runner , master and child. I am getting an error within child where in one line it understands variable master.name and in the next line it gives a NameError as given here " print "Reset name now from %s to %s , oldname %s is saved in mastertrash" %...

Python

9714

What is ONU?

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...

General

10599

Problem With Comparison Operator <=> in G++

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...

C / C++

10347

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

10090

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7635

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6863

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5531

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5673

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4308

transfer the data from one system to another through ip address

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

C# / C Sharp