DLookUp on Report not working 1

[debbieg]

I am wanting a checkbox marked if the person is a first time participant.

I created a query to see who has attended which works fine.

Then as the control source on my checkbox in my report I have the following:

=DLookUp("[SSN]","qselSumAcadFirstTime","[SSN] <> " & [SSN])

I am not getting any checks on my report.

I figure I missing something very simple but just can't see it.

Thanks,
Debbie

 

[rgbanse]

=DLookUp("[SSN]","qselSumAcadFirstTime","[SSN] <> " & [SSN])

not to sure about the <>" & part of the statement but try a quote inside the last bracket
=DLookUp("[SSN]","qselSumAcadFirstTime","[SSN]<>"& [SSN]")

 

[randysmid]

HI,
Is it possible that the text box name you are using is the exact name of a field in your "Field List"? It needs to have a different name, e.g., txtCheck.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[debbieg]

I get a syntax error if I add the " you suggested.

I'm wanting a checkmark if the person is NOT in the the query.

I tried changing the <> to = to see if I got a checkmark and still no checkmarks.

 

[randysmid]

Hi,
What is the name of the field on the report? Does that match up with a field name in your "field list"?

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[randysmid]

Hi,
You actually need an IIF statement to determine if the value is true or not. If true, you want to set the value of the checkbox to "checked"

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[debbieg]

Randy,

The text box name was SSN and the name of the field is SSN. I changed the text box name to txtSSN. I tried:

=DLookUp("[SSN]","qselSumAcadFirstTime","[SSN] <> " & [SSN])
and
=DLookUp("[SSN]","qselSumAcadFirstTime","[SSN] <> " & [txtSSN])

Neither one worked.

Thanks so much for trying to help me.

 

[randysmid]

Hi,
From the first post, you indicated that you want a checkmark. To use this, you really need a checkbox control rather than a text box. Now a checkbox control is unique, in that it uses two basic properties: checked and unchecked (essentially boolean true or false). So, your code will need to use an IIF statement, which will determine if something is true or not. It true, then set the property of the check box to "checked".

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[debbieg]

Randy,

The name of the field on the report is SSN.

I tried:

=IIf(DLookUp("[SSN]","qselSumAcadFirstTime","[SSN] <> " & [SSN]),-1,0)

Still no checkmarks. Weird, huh?

Debbie

 

[randysmid]

Hi,
Here is some code I placed in the OnFormat event of my test report:
If COUNTY_NUMB = "02" Then
Check16 = True
Else
Check16 = False
End If

I tested it, and works perfectly. Only county #2 gets a check mark.


HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[randysmid]

OOOPs,
That is the OnFormat event of the Detail section where my counties are listed.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[debbieg]

I am using a checkbox control.

 

[randysmid]

Hi,
Try this in the OnFormat event of the Detail section where you want the check mark to appear:

If DLookUp([SSN],"qselSumAcadFirstTime",[SSN] <> [SSN]) then
chkFirstTime = True
else
chkFirstTime = False
End If

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[randysmid]

OOPs,
The DLookup does require quote marks around the entries. Here is my FAQ on DSum, which is essentially the same thing:

http://www.tek-tips.com/faqs.cfm?spid=703&newpid=703&sfid=3066

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[debbieg]

Randy,

Works like a charm! Thanks so much!!!!!

Thanks for sticking with me on this.

Debbie

 

[randysmid]

Hi,
Sorry for not catching the whole picture earlier. It feels like Friday to me right now. By the way, I have a sample database that is free. It includes a homemade login screen, homemade menu system, plus alot more features. Just send me your email address, and I will be glad to send to you. It is 2.1MB in zipped format.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association