Opening ms access report based on dates

[OSWOM]

Hello am trying opening a report from a form based on the current record selected which is a date but it cant display the specified DATE record it only diplays all dates please help me with this.....?

THIS FORMULAR WORK WITH OTHER RECODE'S BUT NOT DATES
WHERE CONDITION: ="DATE_PAID=" & [DATE_PAID]
OR
VISUAL BASIC: DoCmd.OpenReport "TUTION_R", acViewPreview, , , , "DATE_PAID = " & Me.DATE_PAID

[NeoPa]

Hi there.

Welcome to Bytes.com.

Let me start by advising that using capitals as you have is considered shouting on the web. You should understand that it's no less insulting or annoying in this context than it would be in real life - so please avoid it in future.

Otherwise, your issue is a very common one. Made worse by the fact that the approach you use generally works in America - but rarely elsewhere. As much of the coding work and examples posted comes from there, and many (Not all but many.) there don't realise the extra complications of portability across national boundaries, there are a lot of examples that won't work reliably outside of that great nation.

For details see Literal DateTimes and Their Delimiters (#). It should tell you everything you need to know on the subject.

[DJRhino1175]

I do something similar, but not with dates. Here is the code I use and should get you what you want.

[Field]=[Forms]![Form Name]![Field]

[NeoPa]

No DJ!

That is absolutely not the right way to handle dates within a SQL string. It works in America - but pretty much nowhere else. Did you even read what I wrote before posting that unhelpful addition to the subject? Date literals should always be strings that are formatted specifically for SQL. The use of default formats is incompetent and lazy, and only for those who haven't yet been told how to do it properly. No-one here any longer has that excuse.