Solved

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

Posted on 2011-02-25
6
519 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:Caracena
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:Caracena
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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:Caracena
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
This article will show you how to use shortcut menus in the Access run-time environment.
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…
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…

760 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

21 Experts available now in Live!

Get 1:1 Help Now