I have an MS Access Data Access Page displaying a report. I wish to change the criteria of the report query by using the rs.filter property in conjunction with a combo box. I just need to check with you guys that this particular property will work with VBscript as opposed to ASP (I currently suspect this is exclusively an ASP property). If anyone can point me in the direction of more info on this rs.filter property, I'd be grateful!!
Here is the code I'm trying to apply it to:
<SCRIPT language=VBSCRIPT event=onload>
Dim DefDate as variant
DefDate = format(dateadd("m",-4,now()), "YYYY/MM")
rs.filter = Defdate
If the code is flawed, please mention it and I'll set up another question specifically for a functional alternative. At this time, I'd be grateful just to know if the rs.filter property can work in a Data Access Page type webpage (VBscript is generally supposed to work with them).