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?
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
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.
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 …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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