Browse through records sorted on dates

[bubben]

Hi

I was wondering. I have a form which have a subform (created from a query). The subform contains all records in the database, which are then sorted on the date which they were entered.

I want to be able to browse through these records, so that only one date at a time is shown in the subform.

If it is possible, I also would like to be able to enter a specific date to show.

Hope you get my drift regarding my problem and that you can help me with this...

 

[Simplycongy]

This is pretty simple, but I thought it was easier to create a sample for you to look

It has one table, one query and two forms (Form1 and QuerySubform)

Select the date from the combobox and the subform automatically refreshes.


Look in the CRITERIA box in the query and the AFTER UPDATE event of the combobox for the code

Enjoy!

 

[bubben]

Hi

That solved most of my problem.
The remaining part is that I would like to have two buttons which I can use to browse through the dates. (So that I don't have to write the date I am searching for).

Hope you understand what I mean

Thanks in advance!