Solved

Continuous Form - Showing additional data

Posted on 2014-03-27
2
262 Views
Last Modified: 2014-03-27
Hi,

See attached simple database.

Customers place orders for car parts!

1.  Run frmHeader which has a subform frmDetail.
2. Choose a customer from frmHeader
3. Now choose a part from frmDetail  (Important: this is a continuous form)
4. So far so good!

Requirement: In the frmDetail - note the two yellow text boxes.   How do I populate these yellow boxes with tblParts.Price and tblParts.Colour

(Obviously, the price & colour are for display only and not stored in the tblOrderDetail)
Database4.accdb
0
Comment
Question by:Patrick O'Dea
[X]
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
2 Comments
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39958229
1. Change the rowsource of Combo0 to:

SELECT tblParts.CarPartID, tblParts.PartDescription, tblParts.PartPrice, tblParts.PartColour FROM tblParts;

2. Change columncount of Combo0 to 4.
3. Add two more column widths - both of 0 (zero) - to ColumnWidths of Combo0.

4. Use as ControlSource for your two yellow textboxes:

    =[Combo0].[column](2)
and
    =[Combo0].[column](3)

/gustav
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39958238
Thanks Gustav,

Works perfectly!
0

Featured Post

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.

Question has a verified solution.

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

Suggested Solutions

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.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

752 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