473,320 Members | 2,158 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,320 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 981
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: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.