Filter a Datasheet (scorecard again, again)

[Fatti]

Ok back to the scorecard again.



What if I want to filter the results, The reason being is there is now data in the competition table and it comes through to the form.



So I would like to filter the results by date at the top with another combo box.

This way if the person wants to edit the results of a previous competition they can just go to that date and edit the data. If they want to add a new competition they can just create another date, fill out the form, save it and thats a new competition.

Or am I on the wrong track and should I just create separate forms for create and retrieve?

[Fatti]

I guess im asking if there is a way to requery the datasheet upon selection of the data combo box at the top. This way I can setup a default start up set (perhaps most recent competition date) and change it once loaded.

[dblife]

You could requery the subform (if that's what it is) by using VB such as,

me!fSubform.Requery

This could be done using a command button or an AfterUpdate() event etc.

But personally, I like to have separate forms for entry and viewing - but that is just my personal preference.

[Fatti]

You could requery the subform (if that's what it is) by using VB such as,

me!fSubform.Requery

This could be done using a command button or an AfterUpdate() event etc.

But personally, I like to have separate forms for entry and viewing - but that is just my personal preference.

Yeah thats part of the problem is its not a subform. Its a form based entirely on a datasheet, but then ive pillaged it and converted some fields into combo boxes that are bound to other tables values in a primary-foreign key arrangement.

I think ive done it all back to front and should have started with the form and subform design rather than create a datasheet form from a table and then trying to modify it.

I might start again I think just to clean it up.

Cheers for the info.