Parameter in a sql string for form

[c8tz]

Hi,

I have a form such that when the user enters the date in the date
field it should show the top 3 dates equal to and less than the date
specified.
I am able to do this in a query but when I use that query as an SQL
string in my coding - it doesn't work -

....code..

sqlstring: select top3 date from frondmarkingtable where date <= "
&txtdate&" ;

this works fine as a query but in the code - nothing happens and no
dates are returned.

Please help.

[Larry Linson]

I'd guess the problem lies in your code to create the string, and no one
will be able to assist until you copy and paste that code into a follow-up.
Clearly, there's no copied code here.

Larry Linson
Microsoft Access MVP

"c8tz" <cc*****@gmail.comwrote in message
news:11**********************@y5g2000hsa.googlegro ups.com...

Hi,

I have a form such that when the user enters the date in the date
field it should show the top 3 dates equal to and less than the date
specified.
I am able to do this in a query but when I use that query as an SQL
string in my coding - it doesn't work -

...code..

sqlstring: select top3 date from frondmarkingtable where date <= "
&txtdate&" ;

this works fine as a query but in the code - nothing happens and no
dates are returned.

Please help.

[Allen Browne]

Answered in microsoft.public.access.modulesdaovba

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.