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.com
http://www.accessmonster.com/Uwe/For...ccess/200510/1

Nov 13 '05 #1

Subscribe Post Reply

3753

Larry Linson

"Chewy1026 via AccessMonster.com" <u8613@uwe> wrote in message
news:5608441cb2ce4@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 "alternative 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
programmatically 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.com" <u8613@uwe> wrote in message
news:5608441cb2ce4@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.com
http://www.accessmonster.com/Uwe/For...ccess/200510/1

Nov 13 '05 #3

Similar topics

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

Microsoft Access / VBA

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

ASP.NET

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

ASP.NET

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

ASP.NET

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

Microsoft Access / VBA

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

Microsoft Access / VBA

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

Microsoft Access / VBA

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

Microsoft Access / VBA

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

Python

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

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

General

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

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

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

Windows Server

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

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

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

Microsoft Access / VBA