Solved

Aceess 2003 Subform

Posted on 2009-07-14
7
213 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now