Hi I hope you can help.

I have two list boxes on a form. The first one displays record id numbers for selection (Combo74). On selection of a number the following routine is run:


Sub Combo74_AfterUpdate()
    ' Find the record that matches the control.
    Me.RecordsetClone.FindFirst "[CaseNoteNo] = '" & Me![Combo74] & "'"
    Me.Bookmark = Me.RecordsetClone.Bookmark

    Me.Combo96.Requery

End Sub

Within the table there can be multiple records with the same record id number. Each of these records have a unique date within it. What I would like to do is select a record id number from one list box, another list box (Combo96) will then display all the relating dates for this id number - on selecting the required date a form will display the correct record.

OR

Would it be easier to setup a subform?????

Hope I have explained this ok.....

Many thanks

Tim

Tim

__________________
Tim

Tim,

To provide a dropdown of only those dates that are related to the selected case, you need to set the RowSource for Combo96. The way to do this would be to put the following before your "Me.Combo96.Requery"

Me.Combo96.RowSource = "Select fieldlist from table WHERE [CaseNoteNo] = " & Me.Combo74.Columns(0)

Whether or not you use a subform depends on your application. It appears you're having the users select a case number to potentially view or edit information that occurred on a specific date. I'm thinking the subform is probably the way to go. But if you want the subform to display data for a specific date instead of all dates, you probably need to include this date select functionality. Then your subform will be linked to both the case number and the selected date.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

That should be Me.Combo74.Column(0) (not Columns)