Solved

Aceess 2003 Subform

Posted on 2009-07-14
7
245 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

832 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