473,614 Members | 2,101 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with Form which contains two Subforms

13 New Member
Good morning,

I have the following structure:
Form Frm_Production_ Main which has two Subforms
SbFrm_Productio n_Sub_MLCD and
SbFrm_Productio n_Sub_TB.
These forms are linked to tables:
Tbl_Production_ Main
Tbl_Production_ Sub_MLCD
Tbl_Production_ Sub_TB

The Record Source for the Form is the following:
Expand|Select|Wrap|Line Numbers
  1. SELECT Tbl_Production_Main.*
  2.      , Tbl_Production_Sub_TB.BC_ID
  3.      , Tbl_Production_Sub_TB.Traceable_Batch
  4. FROM   Tbl_Production_Main
  5.        INNER JOIN
  6.        Tbl_Production_Sub_TB
  7.   ON   Tbl_Production_Main.Batch_Card_ID=Tbl_Production_Sub_TB.BC_ID;
I notice that Tbl_Production_ Sub_MLCD is not mentioned?!

I built the form structure from a copy of previous structure that did not have subforms.

My problem is that new records that I add currently are added to the tables, but cannot be displayed in the form after entry? I know I must have done something wrong but I am not sure what.

Any advice would be much appreciated, thank you.

Anton
Aug 16 '19 #1
1 843
AntonRSL2016
13 New Member
It's ok, I've worked it out, there were entries missing in the sub table!
Aug 16 '19 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
4036
by: Joop | last post by:
Hi all, I'm kinda new to JavaScript, but hey... I'm trying anyway! ;-) So, here's my problem : I've created a table in my document, presenting a list of items, one can 'select' by clicking on it... (Kinda like a menu, you make your choice from) But since this table can get very long, I've put something of a 'search-form' on top, which enables the user to make a
2
4315
by: Andante.in.Blue | last post by:
Hello, I have just inherited a very undocumented legacy database, developed in and still running on Access 97. The file is an MDB file, with no security. It is placed in a shared directory on a dedicated server, but it is usually accessed only by 1 user; the development copy I use is not accessed by anyone else). I am going through the database and fixing logic errors and attempting to optimize the efficiency of the code. I am finding...
1
1253
by: George Papadopoulos | last post by:
Dear community I have recently created an MS-Access database to store and process the various phone numbers, phone devices we use in our hospital. I`m experiencing a problem creating a specific form. In that form I need to find a total count of records in a table subject to an alternating criterion. The criterion is given from a third table. How can I create a dynamic query that accepts a criterion from an edit box? Any help would be...
2
3703
by: insomniux | last post by:
Hi, I have an Access 2000 database with one main form in which all subforms are embedded. In this form I have a timer which closes the form, detaches the linked (ODBC) tables and reopens the same form with a login dialog (initiated in onOpen). When I open the application the form maximizes (as it should). But when the code reopens the form, the form is not maximized. I have DoCmd.Maximize in onOpen,onLoad,onActivate. What else can I try...
7
2606
by: philelpko | last post by:
Good Morning all, I have a main form with 3 subforms. All of the input data on all the forms is stored in the same table. I started getting the message "the changes you requested to the table were not successful because they would create duplicate values in the index". I decided to check that the form was trying to make more than one record on the same ID (Auto Number with no Duplicates allowed) and that windows wasnt lying. After...
1
1357
by: udivitelno | last post by:
Here is the problem: part of the form elements is replaced using Ajax. After this new input elements getting lost from the form so nothing can be POSTed through these input fields. But if I try to append these fields to form using appendChild - they are moved from their places in page and placed diectly after <form> tag. And sure they vanish from the browser and can't be edited. How shall I append these fields to form to not to lose them and...
4
1545
by: TD | last post by:
I have a main form which is unbound. On this form I have two subforms that are linked thru an unbound textbox on the main form. Both both of the subforms are in datasheet view. This setup work great, whenever I select a record in subform1 subform2 is populated with the records for the item selected in subform1. The problem is with subform2. If, say it has three items showing, if I select the second item down the list it stays selected...
2
8382
by: darnel | last post by:
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...
8
2566
by: bruno_guedesav | last post by:
This has ocurred before, but if the person had find a way to solve it or not, I've got no clue. So, here I am to ask for help. I've created a form via pure PHP, basically a bunch of prints together making a form. But somthing strange goes on: the form will only pass it's fields forward under method GET, but not on POST. Here's a snippet of code, just the basics: print "<form name=\"postcomment\" action=\"".HTTP_ROOT."/pages/
1
1799
by: Steve Richter | last post by:
can a desktop icon, used to launch an application window like windows explorer, be a child control in a window form? I checked the windows forms controls in VS2005 and did not see any such control. I would like my code to display all the .LNK files in a directory on a form, handle the single and double click events on the icon, launch the application when double click, ... thanks,
0
8120
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,...
0
8571
jinu1996
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...
0
8423
tracyyun
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...
0
5537
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();...
0
4048
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...
0
4115
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2560
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
1
1705
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1420
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.