Re: Help Pls - 1 Combo box and 1 Date Field on a form to create a repo

Tech-Archive recommends: Fix windows errors by optimizing your registry

post your code, please, both the "working" code for team lead, and the
non-working code that includes the date criteria.

hth


"terushb via AccessMonster.com" <u45650@uwe> wrote in message
news:8929023bca9ff@xxxxxx
Tina, thanks so much, that worked for the Team Lead Part of the code, and
the
report opens up great.. I had left out a perimeter.... so now this is what
I
need assistance on... and then I am good to go... thanks again.. you're a
gem.
. Tbooker

And how stupid is this... I tried to add the Monitor Date field (from
table
TEAM LEAD TRACK)to the form. I want the user to be able to enter the
monitor
date the report will feed off the Team Lead from the Combo Box choice
(from
TABLE TEAM LEADS). I don't think I have the Monitor Date field on the Form
with the Combo Box set up correctly... I have it with control source
=[TEAM
LEAD DAILY TRACK]!MonitorDate....
But I know I am missing something to allow the user to enter the "Monitor
Date" to pull all the records for the report based on the TEAM LEAD choice
from the combo box, and the "Monitor Date" (short date format) they enter
in
the Monitor date field.

tina wrote:
well, if the value of cboteamlead is a Text data type, then you need to
enclose the value in single quotes within the double quotes, as

WhereCondition:="[TEAM LEAD]= '" & Me.cboteamlead & "'"

to add a date criteria to the condition, try

WhereCondition:="[TEAM LEAD]= '" & Me.cboteamlead _
& "' And [Monitor Date] = #" & Me.MonitorDateControlName _
& "#"

hth

Hi to all you wonderful ACCESS Guru's - I am definitely missing
something...
I want a user to be able to create and view the report by the Team Lead
they
[quoted text clipped - 13 lines]
DoCmd.OpenReport "Y-T-D Team Lead Report", View:=acPreview, _
WhereCondition:="[TEAM LEAD]= '" & Me.cboteamlead & ""

--
Message posted via http://www.accessmonster.com



.

Relevant Pages