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
Solved

How to list several fields from different tables in a form?

Posted on 2011-02-25
6
524 Views
Last Modified: 2012-06-21
Hi all,

I'm trying to create a quick application in Access where I can easily see the tasks I have pending but instead of a report, I want to use a form so I can interact with it.

I have a table with some very basic information from each client and other table with the activities I do with each one (send a quote, send a tool, sign a contract, etc.) each one having its own date and all. In a form I can easily see those tasks in a sub-form but I would also like to have a main form (or parent form) where I can easily see a list of clients with their current status (that is saved in the activities list) so I can quickly see the pending tasks.

As I said, I could easily list them in a report but I would like to be able to click on a button (or click on one of the clients) and opena new form with the information and activities for that client so I can modify it.

So far I've been able to create a query that will merge the fileds I need from both tables but they are shown table style... I want to put buttons and actions into it. Can it be done?

Thanks!
0
Comment
Question by:Cesar Aracena
6 Comments
 
LVL 28

Expert Comment

by:omgang
ID: 34980055
You need to create a new form based upon the query you've created.
OM Gang
0
 
LVL 6

Author Comment

by:Cesar Aracena
ID: 34980575
Thanks omgang. The problem is that in form design view, I can only use fields from tables. How do I use query results in forms? Where in 2007 is that?
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 150 total points
ID: 34980680
If your goal here is to display multiple Records in the Main form and multiple records in the subform, ...then this cannot be done directly with basic Main/Subform design.

You will have to view one Main record at a time.
But you can use the combobox wizard to quickly select Customers from the main form.
(When the combobox wizard opens, select: "Find a record on my form...")
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 28

Accepted Solution

by:
omgang earned 350 total points
ID: 34980989
<<The problem is that in form design view, I can only use fields from tables. How do I use query results in forms? Where in 2007 is that?>>
In Form design, view the property sheet and make sure you're viewing the properties for the form and not a control on the form.  Select the Data tab.  Click in to the Record Source property.  Click the drop-down arrow and you will see all the tables and queries you can select as the Record Source for the form.
OM Gang
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34984767
You can use a table, a query, or a SQL statement as a form record source.  Bear in mind that if you have a record source that links multiple tables, it may not be updatable.  This is not a problem with a report, but often it is a problem with a form.  To avoid this, give the main form one table (or a query based on one table, the "one" side of the one-to-many relationship) as a record source, and the subform the "many" table as its record source.  Link them by the key field in the subform's LinkChildFields and LinkMasterFields properties.
0
 
LVL 6

Author Closing Comment

by:Cesar Aracena
ID: 34987000
Thanks guys. I managed to use the quesry on the form but (as boag2000 said) I can't make a list out of them... I still have to start cycling through my customers so I can see each one's status.

Thanks!
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

809 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