Solved

Aceess 2003 Subform

Posted on 2009-07-14
7
235 Views
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???
0
Comment
Question by:Sajib35
  • 4
  • 3
7 Comments
 
LVL 39

Expert Comment

by:thenelson
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.
0
 

Author Comment

by:Sajib35
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....
0
 
LVL 39

Expert Comment

by:thenelson
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?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:Sajib35
ID: 24865979
here that is...
CarNew.mdb
0
 
LVL 39

Accepted Solution

by:
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.
CarNew.mdb
0
 

Author Closing Comment

by:Sajib35
ID: 31603541
Excellent....
0
 
LVL 39

Expert Comment

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

Happy Computing!

Nelson
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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 …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

785 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