K
ken_d128
I have a table with 5 fields and weekNo field tblWeek
fields are
Day1
Day2
Day3
Day4
Day5
WeekNo
This table is populated with 10 years woth of date Monday thru friday
The form I am using is Schedule
When I open this form I would like to Have it open to current date
Where Date()=Either Day1,Day2,Day3 etc
Open to any and all suggestions thank you
Ken
fields are
Day1
Day2
Day3
Day4
Day5
WeekNo
This table is populated with 10 years woth of date Monday thru friday
The form I am using is Schedule
When I open this form I would like to Have it open to current date
Where Date()=Either Day1,Day2,Day3 etc
Open to any and all suggestions thank you
Ken