R
René
I hope that I can explain this simply but adequately.
On my main switchboard, I have several subforms that list client b-days, employee b-day. I previously had a sub-form that stated when the clients needed an in-home visit. This was set on a table where we were manually entering a date 6 months in the future.
I have since created an unbound text box on my client form with the following code in it.
=DateAdd("m",6,DMax("[Review Date]","[Review]","[CustomerID] = " & [CustomerID]))
This is working great in the table and on the client form. What I then tried to do is transfer those numbers onto the subform. It would appear that that was working
on the subform.
So that said I need to do one of two things either sort this so that only the records with a review due during the current month shows up. Or have the month field sorted so that the records due will be those showing in the window (subform on the switchboard)
ReviewMonth: Month([Review.Review Date]) is what is in the Field space of the query for the sub form. Month(date()) is in the critera box. In the table viewof the query it is showing a 7 but on the form is dates for October and January ?????
Hopefully, that made some sense
On my main switchboard, I have several subforms that list client b-days, employee b-day. I previously had a sub-form that stated when the clients needed an in-home visit. This was set on a table where we were manually entering a date 6 months in the future.
I have since created an unbound text box on my client form with the following code in it.
=DateAdd("m",6,DMax("[Review Date]","[Review]","[CustomerID] = " & [CustomerID]))
This is working great in the table and on the client form. What I then tried to do is transfer those numbers onto the subform. It would appear that that was working
on the subform.
So that said I need to do one of two things either sort this so that only the records with a review due during the current month shows up. Or have the month field sorted so that the records due will be those showing in the window (subform on the switchboard)
ReviewMonth: Month([Review.Review Date]) is what is in the Field space of the query for the sub form. Month(date()) is in the critera box. In the table viewof the query it is showing a 7 but on the form is dates for October and January ?????
Hopefully, that made some sense