I have 4 hierarchical tables and want to display it all together as a form and 3 subforms, when subform displays (and allow to add/edit) only relevant items from each superior subform.
Tables are:
Clients --> linked thru id_client --> Orders --> linked thru id_order --> Licences --> linked thru id_licence --> Regkeys
Access' Form Wizard allows only form + 2 subforms. I tried to create last subform and its link manually, but I'm not successful.
2nd subform (Orders) is linked by:
Link Child Fields: id_client
Link Master Fields: id_client
3rd subform (Licences) is linked by
Link Child Fields: id_order
Link Master Fields: [order Subform].Form![id_order]
which is generated by Access and works satisfyingly. I tried to link last subform (Regkeys) analogically as:
Link Child Fields: id_licence
Link Master Fields: [licence Subform].Form![id_licence]
but it doesn't work and all records are displayed instead of relevant.
Only solution that works is to use subform which is form with 2 subforms, but I'd like other solution.
Any advices? Thanks ahead.
--
version: MS Access 2003 Czech (so I hope to use correct terms)
2 8389 MMcCarthy 14,534
Recognized Expert Moderator MVP
As far as I know the maximum of nested subforms is two. However, try this.
Open the licences subform on its own in design view and try using the wizard to add the last subform. This should work. whether the main form will now work with 3 nested subforms I don't know.
Problem solved :-)
I copied and modified linking between 3rd and 4th table (as described before), but miss VB code on Current event (for Licences subform, which on Current event refreshes subordinate subform Regkeys), which should be copied and modified analogically. This code makes requery operation which ensure relevant records in last subform.
Solution you propose will probably work (I tried complete nesting: one form + one subform, where subform is form + subform again...etc), but I don't like this aesthetically ;-)
Anyway thanks for your answer, I "entertaine d" myself with this problem all yesterday without solution.
--
Last note in part "Create a form with two subforms" http://office.microsoft.com/en-gb/ac...CH063650401033 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Arnold |
last post by:
Hi there,
I have a form to organize bottles in mind, but am unsure if it will
work. Here's some background info:
Mainform = frmProduct, which contains fields for pricing, status, etc.
of complete bottles, as well as an image control for a thumbnail of a
complete product (bottle + cap).
The mainform has 2 subforms that must be visible and side-by-side:
|
by: William Wisnieski |
last post by:
Hello Everyone,
Access 2000
I have a main form with a continuous subform. On the main form I have a
text field called . It gets populated based on what the user
selects in a field on the sub form (code in the AfterUpdate
Event). Here's the issue. If the user deletes a subform record. The
field on the main form shows null even if there is a value in the
preceding subform record. What I'd like it to do is immediately refresh to
|
by: Mike MacSween |
last post by:
It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4
subforms.
(I like tabbed forms by the way - do we all?)
Basically the subforms are different ways of looking at the data. It's the
orchestral management thing still.
So tab 1 looks at each musician, the events they're booked onto, which jobs
they're doing etc.
|
by: Dave Boyd |
last post by:
Hi,
I have two very similar forms each with a subform. The main form gets
a few fields from the user and passes this back to a query that the
subform is bound to. The requery is done when the user enters the
last qualifying field on the main form.
In one case this works fine, the subform shows the data the user wants
to update -- which means showing all the data put in previously (ie
showing this via the requery and the continuous...
|
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: Reginald Bal |
last post by:
Hello,
I created a main form with 2 subforms.
In an attempt to move to the next record (or new record) on the main form I
get the error " Method 'requery' of object '_Subform' failed".
The database closes after answering the popup window (Microsoft Access has
encounterd a problem and needs to close. .....)
Does anybody has an idea why I'm having this problem?
|
by: SREDWORB |
last post by:
Hello,
Try to explain this as best as I can.
I have a main form with several cmd buttons, (Not interested in subforms for this project) that opens popup forms.
Example: Main form frmPerson, cmd button cmdVehicle, when clicked opens frmVehicle displaying control boxes to be populated by the user. My problem is that I can't figure out how to link this PopUp Form frmVehicle to the main form, frmPerson.
I tried openargs but when I attempt...
|
by: rlamber |
last post by:
Hello,
I have 2 subforms in a Main form, one links fine, the other doesn't. I am trying to link them both to a "tracking ID" on the main form. The Tracking ID is a text field that is a combination of an auto-number and an Alpha expression. The subform that links fine is a comments form (continuous form with just date field and memo box) and the subform that won't link is a larger, more detailed form where I would like to add more than one...
|
by: c0l0nelFlagg |
last post by:
I need to display a main form with 48 identical subforms. 6 columns with
8 rows.
I set up a separate query for each subform, identical in structure and
underlying data except the criteria in two fields is different for each.
(ie Row and Column id fields).
I am able to select data in each subform from combo box lists, then on
after update event I want to store data in a master underlying
transaction table, both when each subform is...
|
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: 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: 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...
|
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: 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...
|
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
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |