Date fields - Combo Box and Text box

[Richard]

I am using Windows XP and Access 2000.

I have a form with two date fields. A Combo box and a Text box.

How can I make a command button check that these two dates are exactly the
same before Saving and closing the form?

Thanks in advance for any help.

Richard

 

[Linq Adams via AccessMonster.com]

The question that has to be asked here is ***why*** would you want to store
the exact same data in two fields?

 

[Richard]

Please see my post 3 rows down.

Can anyone answer this question?

 

[Richard]

I've solved the problem myself.

 

[Douglas J. Steele]

Be aware that references like "3 rows down" are generally meaningless to
those of us who don't use Microsoft abyssmal web interface to these
newsgroups.

I, for one, use a NNTP news reader, and Linq posts through AccessMonster.

 

[BruceM via AccessMonster.com]

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.

I've solved the problem myself.

I am using Windows XP and Access 2000.

[quoted text clipped - 6 lines]

Richard