Prev: Go Through Records by ScrollBar Control
Next: Change color on date field in form for re-certification
From: BruceM via AccessMonster.com on 12 Apr 2010 10:17
From what I can glean from your brief postings it seems the text box and the
combo box are bound to fields in different tables, one of which has a date
field and the other does not. You want to sort the table without the date
field by a date field in the related table. I don't know which record you
would use if there are several related records, but in any case it seems
having a date field in the main record makes sense.

If you don't want to do that, you may be able to sue a DMax expression in a
query based on the main table to find the earliest date value in a related
record:

=DMax("[DateField]","[ChildTable]","[ID] = " & [ID])

This assumes ID is the linking field, and that it is a number field.

Richard wrote:
>I've solved the problem myself.
>
>> I am using Windows XP and Access 2000.
>>
>[quoted text clipped - 6 lines]
>>
>> Richard

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1

First  |  Prev  | 
Pages: 1 2
Prev: Go Through Records by ScrollBar Control
Next: Change color on date field in form for re-certification