listbox selection

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a main form with a listbox on it that displays the date of entries.
Also on the mainform is a subform that is continuous that the entries are
made. There will be at least one entry per day. The listbox is to select
the date and have the subform go to that date's entry. I have gotten that to
work using the master/child method. But, what is occurring is the subform
does not display anything until a date is selected.

What is needed is to have all the info displayed in the subform when the
form opens and go to the record when the date in the listbox is selected.
How can this be done?

Thanks for the help.
.... John
 
JohnE said:
I have a main form with a listbox on it that displays the date of entries.
Also on the mainform is a subform that is continuous that the entries are
made. There will be at least one entry per day. The listbox is to select
the date and have the subform go to that date's entry. I have gotten that to
work using the master/child method. But, what is occurring is the subform
does not display anything until a date is selected.

What is needed is to have all the info displayed in the subform when the
form opens and go to the record when the date in the listbox is selected.
Click to expand...


The Link Master/Child properties filter the subform records.
It sounds like you only want to navigate to a matching
record. If that's the case, then clear the Link
master/Child properties and use code like this in the list
box's AfterUpdate event procedure:

With Me.subformcontrol.Form.RecordsetClone
.FindFirst "datefield=" & Format(Me.listbox,
"\#yyyy-m-d\#")
If Not .NoMatch Then
Me.subformcontrol.Form.Bookmark = .Bookmark
End If
End With
 
Back
Top