If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to get a field on a form to reflect a certain record of a query?
I have a form (A) that is bound to a table (A) that for example only keeps a
record of name and SSN. The SSN in table A is the primary key. Form B is bound to table B and table B only keeps a record of date, amount , and SSN. The key field in table B is an autonumber. I created a query that shows the results of name, date, and amount in descending order by date. I created a third Form (C) that is supposed to show the results of the query for only one record. I want the fields on Form C to reflect the record of choice. For example, if John Doe has three records, each having a different date, I want Form C to only reflect the most recent record out of the three records for John Doe. Now, I know how to make one form go to a record that is the same as a record on another form but how do you make Form C go to the most recent record in the query based on the SSN shown on Form A? Quick Note: I have a parameter query set up Identical to the query attached to Form C that will allow you to see all the records for lets say John Doe, but again, I'm trying to do this based on the SSN shown on Form A to get a single, most recent record in the query on Form C. Is this possible? If not, any suggestion on how to restructure the database to get this result? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cursor Positioning | Colin Hammond | General Discussion | 3 | November 2nd, 2004 08:42 PM |
New Record Update | Michelle | Using Forms | 5 | October 28th, 2004 07:59 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |