473,803 Members | 3,725 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Sub Form Not saving

DS
I have a Subform that isbased on a Query. Whenever I go to the Subform
and add records in, then go to the next record on the main form...then
back to the previous record on the main form (the one I just added the
records to) the records are gone...but, when I go and check the query
the records are there. Does anyone know whats happening?!!!
Thanks
DS
Nov 13 '05 #1
1 1464
DS wrote:
I have a Subform that isbased on a Query. Whenever I go to the Subform
and add records in, then go to the next record on the main form...then
back to the previous record on the main form (the one I just added the
records to) the records are gone...but, when I go and check the query
the records are there. Does anyone know whats happening?!!!
Thanks
DS


Look towards the foreign key column of the subform, is this being filled
in when you enter the record?

It's normally filled in automatically if you have the "Link
Master"/"Link Child" properties set on the subform's control.

--
Pretentious? Moi?
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
3986
by: Lyn | last post by:
Hi, I have a form which is opened from a button on another form. The form is used to display a list of records from a recordset in Continuous Mode. It is sized vertically to display about 25 rows and has a vertical scrollbar. This form has been working perfectly for weeks. However, I must have done something recently because now the detail section displays only one row at a time. That is, the form has shrunk vertically to about 3 cm...
7
1969
by: Marty | last post by:
Hi, I want to save the form position when the user close it. I tried to place the coordinate saving code in my destructor, but it is not triggered when I assign the form to null. Where should I place my code to save the coord. when the form close? Thanks Marty
4
3761
by: microb0x | last post by:
I have an application with a master form with a tab control containing nine tabs, each tab contains a subform. I have command buttons on my main form including: Save , Cancel , Close. My question is, how can I prevent Access from auto-saving changed or entered data on both the main form and any subform? The main goal is to force the user to use the 'Save' button to save any data. I need the 'Cancel' button to just undo any changes...
11
3710
by: TD | last post by:
I'm looking for input into my decision to switch to ADO and unbound forms. I get tired of having to block all of the ways a user can unknowingly save a record, like using the PageUp, PageDown keys and the scroll wheel on the mouse. Also, I think that as the database grows in size that it will eventually be moved to SQL Server 2005 Express. With all of that said I started using ADO to manually work with my unbound forms. It is a lot of...
0
1236
by: Miro | last post by:
Something I have run into using VB Express 2005 with mdi forms. I have not been able to re-create this but I'll let out the information on how I came about fixing this. As it cost me about 4 hours last night so it might be a good read for anyone who uses mdi's. 1. I have Parent form that is an MDI conatainer. On the top of the form I have a panel docked, and on the left hand side of the form I have a panel docked with a splitter....
17
11917
dbanning
by: dbanning | last post by:
I am trying to save the contents of a form as a bitmap and am unsure how to do this. I can use the savepicture command to save the form as a bitmap but the contents is not intact as you would expect. There is 1 picture box on the form which I wish to save with the form so really a full screen shot of the form. Taking a screen shot and saving it won't do it either as the form is only a section of the screen say 640 X 480 and is centred on the...
0
905
by: castlegrpsf | last post by:
I have a win form using VB.NET that needs to set some values prior to updating a SQL database. The values being stored are computed at the time the user is saving the data. It is based on other data fields on the form, that are bound to the data source. Where can I accomplish this. (1) Field validation will not work since not all fields on the form need to be completed prior to saving. (2) Form validation Me.Validate does not seem to...
6
2276
by: Thom Little | last post by:
Using C# 3.5 I have a form that calls many other sub-forms. Typically there will be five forms open at the same time. If the main form is closed all the sub forms are also closed. Is there a standard way to gain control within the sub-forms to do individual clean-up prior to their removal?
6
1688
by: =?Utf-8?B?anAybXNmdA==?= | last post by:
Can a Form be set to Serializable? My App keeps crashing ever time I attempt to serialize the form. I was under the impression that Serialization could be used to easily save all of my data. If the form can not be serialized, how to I save the information on it?
11
5326
by: V S Rawat | last post by:
using Javascript, I am opening a web-based url in a popup window. MyWin1=Window.Open(url, "mywindow") There is a form (form1) in the url in that popup window, I need to submit that form. How do I submit that form1 from the javascript from my current window? Thanks.
0
9703
marktang
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...
0
9566
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
10317
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...
1
10300
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,...
0
6844
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
5503
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
5636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4277
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
2
3802
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.