A
abev107
I 'll try and explain as best I can...
I have a report based on a recordset...I am working with two fields
ctlDate and ctlLocation
when I set the control source of the control to =[ctlDate] & "
[ctlLocation] it displays without a problem....
but when I try and set the value from the detail section onprint even
like this:
If ctldate = #3/1/04# and ctlLocation = "Store" then
me.txtMon = "This works"
End if
For some reason ctldate is empty but ctlLocation has a value. In th
recordset they BOTH have a value. I checked by putting a control base
on ctlDate right next to it in the report and it shows.
I can access both of the fields thorugh the text box recordsource wit
an IIF. I would do it that way by I need to do a Select Case to ge
what I want.
My ques is why is ctlLocation avail to me in the module, but ctlDat
isnt
I have a report based on a recordset...I am working with two fields
ctlDate and ctlLocation
when I set the control source of the control to =[ctlDate] & "
[ctlLocation] it displays without a problem....
but when I try and set the value from the detail section onprint even
like this:
If ctldate = #3/1/04# and ctlLocation = "Store" then
me.txtMon = "This works"
End if
For some reason ctldate is empty but ctlLocation has a value. In th
recordset they BOTH have a value. I checked by putting a control base
on ctlDate right next to it in the report and it shows.
I can access both of the fields thorugh the text box recordsource wit
an IIF. I would do it that way by I need to do a Select Case to ge
what I want.
My ques is why is ctlLocation avail to me in the module, but ctlDat
isnt