Query re-run for Tomorrow/Yesterday

[mseeker22]

Hi,

I have a basic restaurant booking database in the making. The query linked to the continuous form shows all bookings for the date entered or if blank then todays date -

IIf(IsNull([Forms]![BookingsDiarySearch].[DiaryDateEntry]),Date(),[Forms]![BookingsDiarySearch].[DiaryDateEntry])



This all works fine but once this has been run I then want to be able to view tomorrows or yesterdays diary by simply clicking a command button. Not sure how to go about doing it? Any advice would be great.

Cheers

Luke

[June7]

Have buttons 'View Yesterday' and 'View Tomorrow' then the filter criteria would be the current date plus or minus one day. So the buttons would modify the date value in the textbox with: Me.DiaryDateEntry=Date()+1 (or Date()-1)

[mseeker22]

Thanks, although I'm still struggling. At present the 'DiaryDateEntry' tbo is on a separate form.

With the new 'View Yesterday' cmd button for example, am I getting it to close form and then openform with filtered criteria . . . Is that correct?

I may just be putting the filter in the wrong place, I am putting it in a macro (I don't know how to write the same instructions in vba).

How do I get it to ensure it applies the filters using the date that has already been selected and currently being viewed. Do I need to be using a TempVar?

Probably just confusing the matter!

[June7]

Oh, sorry then replace the Me with [Forms]![BookingsDiarySearch]

Because you are referencing the date as a parameter in the query the form is based on, this filters the form to a limited recordset. Changing the criteria requires requerying the RecordSource. It is not necessary to close then reopen the form to accomplish but that does work.

I don't use macros, just VBA. Easier to debug and more versatile. But suppose in macro could use the form Requery method. It would be like [Forms]![BookingsDiarySearch].Requery