How to change the linking fields on a subform

I have a subform but want to change how they are linked

How can i do this


10/22/2007 4:57:30 PM
access 16762 articles. 3 followers. Follow

4 Replies

Similar Articles

[PageSpeed] 40

Open the parent form in design view and select the subform control; that's 
the control which houses the subform.  In its properties sheet change the 
LinkMasterFields and LinkChildFields properties.  The former is usually the 
name of a field in the parent form's underlying table or query, and the 
latter the name of the corresponding field in the subform's  underlying table 
or query.  The subform will return rows where the value of the field in 
question matches that of the field in the parent form's current record.

Bear in mind that the LinkmasterFields property can also be the name of an 
unbound control in the parent form, so you could have an unbound combo box 
which lists all customers say, and the subform could show the selected 
customer's orders.

Also the properties can include more than one field name, separated by a 
semi-colon.  Both properties must include the same number of field names, 

Ken Sheridan
Stafford, England

"Simon" wrote:

> I have a subform but want to change how they are linked
> How can i do this
> Thanks

10/22/2007 5:57:02 PM
You have to bring up the subform *control* properties.  To do that, 
right-click on the very edge of your subform. It's a little tricky to find. 
If you click in the subform, you'll get the properties for the form 
contained in the subform control.  But if you click the edge, you get the 
properties of the subform control.  You can tell when you have the right 
one, because the property box heading will say Subform/Subreport: followed 
by the form name.  When you're in the form property box, it will just have 
the form name.

--Roger Carlson
  MS Access MVP
  Access Database Samples:
  Want answers to your Access questions in your Email?
  Free subscription:

"Simon" <> wrote in message
>I have a subform but want to change how they are linked
> How can i do this
> Thanks

10/22/2007 6:00:25 PM
On Mon, 22 Oct 2007 09:57:30 -0700, Simon <> wrote:

>I have a subform but want to change how they are linked
>How can i do this

Open the main form in design view. Select the subform control - the box
containing the subform, not the form within that box - by clicking the edge of
it, or selecting it from the dropdown box listing all the controls on the form
(to the left of the toolbar).

Set the Master Link Field and Child Link Field properties as appropriate.

             John W. Vinson [MVP]
10/22/2007 8:17:48 PM
"Simon" <> wrote in message
>I have a subform but want to change how they are linked
> How can i do this
> Thanks

10/24/2007 2:15:13 AM

Similar Artilces:

TempVars unusable in field default value
Hello, I'm trying to use a temporary variable to keep track of which CSR is inputting data. I have a macro which prompts user for ID code, which is stored in the temp variable TempUser. On a form control default value property, I can use the expression [TempVars]![TempUser], which will populate that user's ID code into the control. However, I cannot use that same expression in the tables field default value property. If I try, when I save the changes to the table, I get the error message "Could not find the field 'TempVars]![TempUser'. " Any ideas why I ca...

send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with one or two fields changed (for example the name of recipient and the date).How canthis be done?? I would also like to be able to save the e-mail and use it again and again. can anyone help cheers john If you have Word installed and it's the same version as Outlook (both 2003, for example), you can do a mail merge between the two. This would allow you to set up the text the way you want it to, and you can save the document for future use. Look at the following page for further information:

How to link with an Access DB
Hi, I have an Acces DB with many tables. I need to choose the name of a customer in a cell of Excel. For example, in acces I have this tables: Table1 Id Name Last Name City I need to choose the last name from a drop down menu in a spreadsheet and then in other cell I need to put all the data regarding the last name that I choose. I hope to be exaustive, and sorry for my english. :-) Many Thanks Stefano ...

why does sorting change a scatter plot graph?
Why does the way a spread sheet is sorted change the look of a scatter plot graph??? the graph is just a plot of two points, (X, Y) and these two points are definded by two collumns for a given row. The two collumns don't change, and the row all stays together, so why does it change where points are plotted out on the graph when you re-sort it? AndrewT420 - Usually, for an XY (Scatter) chart, with values of X in a column and corresponding values of Y in an adjacent column, for three or more points, Excel assumes (correctly) "Series in Columns." But, when you have only...

Changing Prices in HQ.
Hi, I have this little issue. I want to change the put items on promotion using the price wizard using HQ. Unfortunately if I have stores who has differents prices for a same item the wizard do not make the proper change becuase it use the price already stored in the master table. Does anyone saw this issue before? Who was solved?. Thks in advance for your help. Rgds Rodrigo Hi there, The easiest way to look after this is to not change any data on the ITEM in HQ, but to simply do the worksheet for altering the sale price and then send it to the respective stores. Then in the works...

Content of emails is changing without any reason !
Hallo I changed operating system last week. From Win XP to Win 7. Used to work with Outlook Express at full satisfaction. I could transfer most of my emails automatically with export/import features of Microsoft software. But I suddenly discover 1 very big problem (bug ???) I am used to work with several maps, and hereby go to several levels deep. Such as : Saved mails Companyname Projectname Date of action Department Activity Name of patient Different emails So sometimes maps can go several levels deep. When I check ema...

Table link documentation
I am having trouble trying to locate A/P check data that has project related costs. I found the check data but it is does not indicate the projects, I found the project data but can not determine thye logical link between the two tables, I may be using the wrong tables the tables I am using are PM80500 and PA31102. Is there any documentation of how all the tables in the system are logically link. I am trying to write reports in MS Access, but there are 1500+ tables in GP (version 10) -- Dave F In an effort to find the correct table you can do a number of things (believe me I do)....

Saving toolbar changes
After spending a lot of time to customize a toolbar in Excel 2003, it disappears when opening up another file, or starting the app again. I repeatedly change it, save it as XLB, XLT, save multiple copies in every possible location...but the damn thing always defaults to its own toolbar settings. This makes toolbars almost useless. How can one insist that PPT use YOUR toolbar setting, rather than its own default Thanks. Hi Jeff, If I have a lot of tool bar changes to make, I close all the workbook that are not hidden then unhide my personal.xls from the Window menu. I don't know why...

Field Service Calls and Invoices
We use the Service Call modules for repairs in our Stores and have a situation that I'm trying to find a workaround. We have situations where our technicians will pick-up items without prior notification to our dispatchers. All of a sudden we get an invoice and currently we have to track down the charge and then we are forcing a PO into the system from the Service Call in order to properly receive and enter the invoice. Does anyone have other ways to do this and track the information/cost on the Service Call without needing to create a PO after the fact. This is not an applicat...

Change cannot be saved due to sharing violation
Hello I've this message while saving the excel file even if no change ha been done to the file. There is no share on this file (exclusive use) File resides on a network drive It's very disturbing Thanks for your help Vobiscu -- Vobiscu ----------------------------------------------------------------------- Vobiscum's Profile: View this thread:;en-us;328170 Thanks for your answer, I will try tomorrow noo Vobiscu -- Vobiscu ----------------...

Changing query execution sequence
Hi all, I got a spreadsheet which would execute a bunch of queries. It's noted that the queries are executing in the sequence of when it was added to the spreadsheet. Does anyone out there know of a way to switch the order without deleting and recreating them? Thanks! Wing ...

How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the current form field. This bit of code is attached to the GotFocus event of all fields and the Enter event of all subforms: gxCurrentField = Me.ActiveControl.Name However it doesn't work properly when changing records in a subform. My parent form contains two subforms in a many-to-many relationship. The above variable usually ends up containing the name of the first field in the second subform when switching records in the first subform. How to correctly code this? Or is there some native variable I'm not aware of? I...

Outlook 2003
In Outlook 2003, #1 Is there a way to refresh the unread folder so that read messages no longer apear? Right now I have to click closed the unread folder and click it again #2 Is there a way to create a toolbar button that goes directly to a subfolder? Thanks ...

Automatic changes in cells
Hi for some reason I now have to save my work for any formlas etc to change when I update a worsheet, how can I stop this as it is a pain and sometimes I need to do changes to see how they work before saving the work. Many thanks Click on Tools | Options | Calculation tab and set to Automatic calculation, as it is probably set to Manual. You can press F9 to force a recalculation under a manual setting. Make sure you save the file with the Automatic setting, to avoid it happening next time. Hope this helps. Pete On Feb 1, 11:42=A0am, Office 2004 Test Drive User <

Change the text of a shape rather than its master
Hi, I build custom masters by mixing two general shapes, say square and circle together, and have text on both the shapes. But after I drop an instance of the master into a page, I cannot modify the text of the instance. To do so, I need to modify the text on the master, which is non-sense for me. How to change the text of a shape without modifying its master? Thanks! How are you doing this? By code or by the UI? Are you grouping the shapes? If you drag two shapes to the stencil, it will group the shapes. So instead of a square and a circle you have three shapes. A Square, Circle and the...

cell colour change when set markers are reached
i need to get a cell to change colour when markers are reached eg a qualification lasts 12 months. what i want to do is have the cell change from yellow to orange to red as the expiry date gets closer. If column A contains expiry dates then select column A, Formats>Conditional Formatting>formula1: =DATEDIF(TODAY(),A1,"m")<1 red for 1 month Click Add button, formula2: =DATEDIF(TODAY(),A1,"m")<2 orange for 2 month Click Add button, formula3: =DATEDIF(TODAY(),A1,"m")<3 yellow for 3 month Adjust number of months as you like! Regards,...

Opening Multiple Web Links in a Column
Hi, I am very new to using web links in excel. A task I do very often is open a list of different websites that are in various columns in an excel spreadsheet. I am quite sure I am doing it the slowest way possible, so I need some help please. Basically I have been clicking on one link at a time. When I do this, the first website opens and excel automatically minimizes, then I have to go re maximize excel and then click the next web link and the same thing happens, etc... very time consuming. I am wondering if there is a way, either through Excel or whatever means necessary, to open all...

Changing ip address of exchange server #2
Hi, I have a back-end server and a smtp server in DMZ. I want to change ip address of back-end server. are there any issues? all incoming and outgoing emails are going via smart host. Hi, No issues at all as long as you remember to change all the references to this server in your firewall, SMTP scanner etc. Leif "Jack Dorson" <> wrote in message > Hi, > > I have a back-end server and a smtp server in DMZ. > > I want to change ip address of back-end server. are ...

Duplicating one Field from One table to Another
Hi - I have two tables - one position, one personnel - which has a 1-to-many relationship (1 position record to many personnel records). The department had a new requirement which made it necessary to change some coding (I inherited this). I'm using tab forms so that when a position is pulled up, you can click on the tab that has the personnel information (if there is any). There is a button on the Personnel form that allows the user to add a new Personnel record. Since I am using an Auto-number field in the Position table (which doubles as the PK) the functionality is fine. Wh...

How to change a background color with Publisher
How can I click on to a background color and change that background color to another color using Publisher? Ron Williams wrote: > How can I click on to a background color and change that background > color to another color using Publisher? ====================== Try these steps... Double left click the color you want to change and a Format screen should open that has a drop window with color choices. -- J. Inzer MS-MVP Digital Media Experience Notice This is not tech support I am a volunteer Solutions that work for me may not work fo...

how do I change date format in the header in Excel XP ?
I need to chage my date format, in the header to Day; Month DD, YYYY ie. Saturday; May 23, 2005. Woudl you please help me out ? Thank you. Regards, Hesam Shakourian Check this out. but change the format to "dddd, MMMM dd, yyyy" "Hesam" <> wrote in message > I need to chage my date format, in the header to Day; Month DD, YYYY > ie. Saturday; May 23, 2005. > > Woudl you please help me out ? > > Thank you. > &g...

Chart Linking
How can a cell in one workbook be linked to data in another workbook. Kenneth Hi try the following: - open both workbooks - in the target workbook enter the equatrion sign '=' - now select with your mouse the source cell in the other workbook and hit ENTER -- Regards Frank Kabel Frankfurt, Germany "Kenneth" <> schrieb im Newsbeitrag > How can a cell in one workbook be linked to data in another workbook. > Kenneth > > Or copy the source cell, select the target cell, choose Paste Special from the Ed...

Change Domain Name on outgoing Emails
Our company just purchased another company with their own Exchange Server and AD infrastrure. We want all users in this new facility to have Email addresses with our Domain such as instead of their current Domain Until I migrate resources from their Forest into our Forest I have created contacts to forward all Emails from the abc Domain to the 123 Domain. When users reply or send Emails from the 123 Domain it still has their Email address which will cause confusion with our customers and suppliers. How do I force their Emails to us...

Link Outlook 2003 to Exchange 5.5 over VPN
Hi How do you do it?? I have a VPN, I can ping the ip of the mail server (NT4) but cannot see it when I test from within Outlook 2003 exchange account Cheers Colin Put the IP address and server name of the Exchange server in your local computer's hosts file and see if you can then ping by name - if you can, you ought to be able to access the mailbox. That's just one quick way to do it....but it ought to work. Colin wrote: > Hi > > How do you do it?? I have a VPN, I can ping the ip of the > mail server (NT4) but cannot see it when I test from > within Outlook 2003 e...

How to change PERMANENTLY environment variables from batch script?
Ok, I know. In a batch file I can change environment variables temporarily (=for the current, remaining session) be entering e.g. set CLASSPATH=D:\newpath;%CLASSPATH% However these changes are not visible outside of the current session and furthermore they are lost after a reboot. Is there a(nother) way to change them PERMANENTLY from batch script? I can imagine that there is a way by a regedit or VisualBasic script or 3rd party cmdline tool. Again: I don't want to edit them manually e.g. in the "System" dialog in control panel. The change should take place on ...