I have a form that is used to open another form using command button. I want the 2nd form to filer out records based on criteria from the fist form. I have looked over postings but cannot seem to get it to work.
Here is code I am using, criteria being used is persons name and month
Dim stDocName As String
Dim stLinkCriteria As String
You only use the "#" (hash or number sign or pound sign, depending on where you live, see: Number sign - Wikipedia, the free encyclopedia) with Date/Time data type values and I suppose that Me![Month] returns an Integer, not a full date.