Date activated query!

[Bob Vance]

If my tblHorseInfo has these fields HorseID.Number, DateAlert.Date/Time ,
AlertInfo.Text
How would I design the query to show this on the Date Set
I am going to have a Listbox [ListAlert]on my Main Menu that will be visible
when there is a record to Show
Me.ListAlert.Visible = IIf(Me.ListAlert.ListCount = 0, False, True) showing
these 3 fields

 

[Bob Vance]

If my tblHorseInfo has these fields HorseID.Number, DateAlert.Date/Time ,
AlertInfo.Text
How would I design the query to show this on the Date Set
I am going to have a Listbox [ListAlert]on my Main Menu that will be
visible when there is a record to Show
Me.ListAlert.Visible = IIf(Me.ListAlert.ListCount = 0, False, True)
showing these 3 fields

Ok worked it out
SELECT tblHorseInfo.HorseID, tblHorseInfo.MemoDate, tblHorseInfo.MemoText
FROM tblHorseInfo
WHERE (((tblHorseInfo.MemoDate)<Now()) AND ((tblHorseInfo.MemoText) Is Not
Null));