PC Review


Reply
Thread Tools Rate Thread

Adding a query result to a form in Access 2007

 
 
New Member
Join Date: Jun 2010
Posts: 4
 
      15th Jun 2010
I want to display the results from a query on a form.
My form is a basic Tasks form
I have a query that get the task original due date and revised due date from the tasks table and returns two variables. 1) the calculated due date and 2) whether it is overdue.
That was easy. Now how do I display the calculated due date and whether it is overdue in the top corner of my form? Seems easy enough but with all my reading on querys it doesn't seem to be obvious.

My form is based on the Tasks table, not based on a query. When I try to search for available fields to add to my form it doesn't have query results there. When I try and drag and drop the query on the form it tries to create a subform. I don't want a subform just a basic little note in the corner to say if it is overdue.

Thanks in advance!
Lara
 
Reply With Quote
 
 
 
 
New Member
Join Date: Jun 2010
Posts: 4
 
      16th Jun 2010
Ok I worked it out again. I would have thought there was an easier way to add a query to a form as everything else is drag and drop.
I added a text box to my task form and then in the control source for that control I added an expression:
=DLookUp("[DerOverdue]","CalTaskDueDate","[CalTaskDueDate]![TaskID]=[ID]")
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link Excel form to Access query result or any other ADO =?Utf-8?B?RGFu?= Microsoft Excel Programming 2 22nd Jun 2007 04:41 AM
Link form to Access query result =?Utf-8?B?RGFu?= Microsoft Excel Programming 3 21st Jun 2007 10:07 PM
How to display result of query on a form in Access? =?Utf-8?B?QWluYQ==?= Microsoft Access Form Coding 1 4th Oct 2005 09:46 PM
How to display result of query on a form in Access? =?Utf-8?B?QWluYQ==?= Microsoft Access Forms 1 4th Oct 2005 06:37 PM
adding form field result to query - urgent =?Utf-8?B?Um9iZXJ0X0xfUm9zcw==?= Microsoft Access Queries 4 13th May 2005 08:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:13 AM.