473,385 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

MS Access Passing Data in Forms

I have an Access database where I am trying to use a form with subforms. There are 3 tables linked to one another. After I have created the form with the two subforms, everything works fine (all data is correctly showing in all forms). However, when I go back to the main form to locate a record to update, the subforms don't bring up any data. The subforms are blank. Why does it work when first opened (all forms are correct), but when searching for a specific record, the other two forms don't show data.

I am a novice programmer but willing to learn. Any help is very much appreciated.
Jan 27 '15 #1
4 984
twinnyfo
3,653 Expert Mod 2GB
Do you have the proper Master-Child relationships established with your subforms? You have not provided a lot of information, so we have to guess as to what the problem may be.
Jan 27 '15 #2
Yes, all tables are appropriately related.
Jan 27 '15 #3
twinnyfo
3,653 Expert Mod 2GB
But, have those relationships been properly applied to the Forms/SubForms? When two tables are related by a common Primary Key, and those tables are properly configured on Forms, when the master Table moves to a new record, the subforms should automatically filter by only the related PK. Your problem "sounds" like a Master-Child issue on the Forms--not between the tables.
Jan 27 '15 #4
zmbd
5,501 Expert Mod 4TB
Here,
try this example:Create a form that contains a subform

The relationships must be setup at both the table and the form levels. Although similar, the relationships at each level serve different purposes.
Jan 27 '15 #5

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

Similar topics

1
by: Rob Oliver | last post by:
Hi, I've seen a walkthrough for passing data from a setup project to a custom action (an application) with an InstallClass. I am curious though--can the data also be intercepted by a custom...
3
by: Simon Harvey | last post by:
Hi, In my application I get lots of different sorts of information from databases. As such, a lot of information is stored in DataSets and DataTable objects. Up until now, I have been passing...
3
by: Brian Smith | last post by:
I have a .aspx page (we'll call it Form1) with a datagrid on it. The datagrid is populated from a dataset that I manually entered data into (the data isn't in a database). The datagrid on Form1...
1
by: msyez | last post by:
HI, I have 3 pages where I collect userdata that I want to show in a confirmationpage. Which is the best way of passing data from page1 to page4, page2 to page4 and so on? I like public property...
3
by: Marc Castrechini | last post by:
First off this is a great reference for passing data between the Data Access and Business Layers:...
2
by: Jason L James | last post by:
Hi all, I am trying to browse a table in my MS Access DB from a web form, using a bound datagrid. The DB is populated, and the grid in on the web form. When I execute the following code: ...
3
by: Lonewolf | last post by:
Hi all, I'm having difficulties passing data back to managed class from my native class when the data is generated from within a native thread in the native class itself. I will give the following...
2
by: MyEmailList | last post by:
We have an Access data base with severl tables, queries and forms. We want to put it on the web. Is there a tool that will convert the Access queries and forms to ASP? Sorta like "splitting"...
3
by: OG | last post by:
I'm trying to learn C# 2008 on Microsoft's MSDN. Their walkthrough example on passing data between forms at http://msdn.microsoft.com/en-us/library/ms171925.aspx had this error in the C# version...
1
by: kondi69 | last post by:
Hello, I'm right newbe in c# but I have big problem with passing data between forms. Below code: : public Form1 main = new Form1(); public int opuwminuty;
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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,...
0
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...
0
Oralloy
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,...
0
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...

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.