Max Date problem (1 Viewer)

[Niniel]

Hello,

I have a subform with a combo box. The data for the combo box is limited to show only the record with the most recent date - and when I go to look at the row source list, it does show only the most recent record - yet whenever I select that entry, it pulls up the older data.
Why is that, and how can I get around it?

Thank you.

 

[Niniel]

I guess I should say that I have conflicting goals here - I use the same form for adding new records and editing existing ones. When I create a new record, I need the combo box to show the record with the most recent date, but when I edit records, I need the date shown that as entered, not the most recent one.

The only way that I see around this dilemma is to have separate forms for adding and editing with separate queries to populate that box. It would be nicer though to use the same form.
Can it be done, and if so, how?

 

[Niniel]

I found a solution - If Me.NewRecord Then... in the main form's Current event let's me specify different Select statements for adding vs. editing records.