programing a button

[inbal]

i have a sub form showing me all my activities.
* i want to create a button that by pressing it i will only get the future activities.
(now i get future and past activities)
* i want a button that by clicking it I will get all the activities with a sertain word in field X.
thanks

 

[ted.martin]

This is a qucik way that may work for you
Create a button on your form and then using a little bit of code:

Change the RecordSource to a Query where the your datefield > Date()

Private Sub Command52_Click()

Me.RecordSource = "Q-Fault Log dated"
End Sub

Just tested in and it works a treat. To revert, then amend the code via an If statemanet to call the original RecordSource query.