Current Month and All filtering of records?

[Bayou BoB]

Hi!

Another quick question so I thought I'd ask in a new thread since it's
a little different.

When the log book form comes up to let people read all the log entries
(by date).....you get every entry ever made. I was wondering how to
add a small two option, option group at the top that allows the log
book to be filtered and viewed as either "Current Month" and "All"....
and would it be coded under the AfterUpdate properties? Or the OnClick
properties? Many thanks! You have all been wonderful, patient and
helpful.

Kevin

 

[Larry Linson]

Put code in the AfterUpdate of the OptionGroup to create a modified SQL
statement and replace the RecordSource property of the Form with the new SQL
statement. But if there are only two options "Current Month" and "All", you
really only need a single Toggle Button to select.

Larry Linson
Microsoft Access MVP

 

[Bayou BoB]

Thanks. What would the modified code look like Larry? I'm not sure how
to go about writing that...? Thanks again.

Kevin