MS Access - Check Box to show updated records in List Box
Posted on 2009-04-11
I have three tables with the column Updated_Date
What I would like to happen is:
If the Updated_Date in any of the above tables is greater than 1/1/2009,
then I would like the Companies to show in my ListBox (Control Name: List16)
My form name is CompanyMain
Currently the rowsource for List16 is:
Me.List16.RowSource = "SELECT Company.Company_Name, Company.DUNS_Number FROM Company GROUP BY Company_Name, DUNS_Number;"
Note: Company.DUNS_Number is Unique and shown in all tables.
If the Box is UnChecked the ListBox would revert to it's orig list.
Or I have a Reset Command Button I could add a line to to clear the criteria...
Thanks for your help.