Aceess 2003 Subform

Posted on 2009-07-14
Last Modified: 2012-05-07
I have created a form which is link to its subform A. Now i want to make another subformB inside subformA, SO if i select any data in Subform A the data in Subform B can chaged.
Can anyone tell how can i do that???
Question by:Sajib35
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 39

Expert Comment

ID: 24855312
You create the sub-sub form subformB inside subformA just like you created subformA inside the main form. The subform wizard will help you link subformA to subformB.

Author Comment

ID: 24856743
I have created the Subform B  and that is appear on design view but as soon as i go to form view the subform bring another form altogether....
I better explain my problem ....
I want to get the product Id and two input criteria in the first form and then based on that creiteria to bring the product details in Subform A. Now when the Subform A is created with some of the product info, i want to create a Another subformB which will chage when user point one product in subform A.
i.e: Top form shows the car ID and make and two creteria like purchase in between...
Subform A populate the deatils for car like make ,model, kms.... and now when user highlight or click on one perticuler make that will show the car condition in subform B...

I hope someone can help....
LVL 39

Expert Comment

ID: 24857653
<that is appear on design view but as soon as i go to form view the subform bring another form altogether>
Can you post images or a sample DB?
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.


Author Comment

ID: 24865979
here that is...
LVL 39

Accepted Solution

thenelson earned 500 total points
ID: 24866233
Your problem is your subform "CarDetailssubform" was setup in datasheet View which cannot display a subform. I changed it to continuous form.  I also fixed some other problems you had.

Author Closing Comment

ID: 31603541
LVL 39

Expert Comment

ID: 24901397
Glad to help and thank you very much for the points with "A" grade!

Happy Computing!


Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question