Parameter query

Hi forum,

I have an unbound form with a Calendar control (9.0) Two unbound text boxes,
option group, and a command button. I all ready have the calendar working the
way I need it. When I pick a start date it places that value in my startdate
textbox, and the end date in my enddate text box. I need to pass those values
to a parameter query via my command button but, have been unsuccessful. I was
trying things like this Between [Start Date] And [End Date] but it throws
up a dialog box. I just want to pass the two values to the query without the
dialog boxes. I hope I was clear enough thanks.

Richard

Between Forms!NameOfForm!NameOfStartDateControl And
Forms!NameOfForm!NameOfEndDateControl
--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"Richard" u53223@uwe wrote in message news:98f3a8e3aab87@uwe...
Hi forum,

I have an unbound form with a Calendar control (9.0) Two unbound text
boxes,
option group, and a command button. I all ready have the calendar working
the
way I need it. When I pick a start date it places that value in my
startdate
textbox, and the end date in my enddate text box. I need to pass those
values
to a parameter query via my command button but, have been unsuccessful. I
was
trying things like this Between [Start Date] And [End Date] but it
throws
up a dialog box. I just want to pass the two values to the query without
the
dialog boxes. I hope I was clear enough thanks.

Richard

Brilliant.

Thank you


Ken Snell [MVP] wrote:
Between Forms!NameOfForm!NameOfStartDateControl And
Forms!NameOfForm!NameOfEndDateControl
Hi forum,

[quoted text clipped - 15 lines]

Richard

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200907/1