If Nz(DLookup(... Not Working

[Guest]

Here is my code, and it is not working the way I want it to:

f Nz(DLookup("bShow", "tShowDialogs", "sFormName='" & Startup & "' AND
sUserName='" & CurrentUser & "'"), False)= True Then
'/open you dialog form
DoCmd.OpenForm "Startup"

End If

If checkbox "bShow" is false, then this code should open form "Startup", and
if it true, then this code should do nothing (this code is reference in an
autoexec macro). Instead, regardless of the checkbox, this code does
nothing. If I change the code to:

If Nz(DLookup("bShow", "tShowDialogs"), False) = False Then
'/open you dialog form
DoCmd.OpenForm "Startup"

End If

Then it works. This takes away from it being able to adjust for the user,
though. So how do I make it work?

 

[CyberDwarf]

I assume you are looking up these values in a table called tShowDialogs? If
so, and your table is on SQL Server, then beware of True/False values!
False will always be Zero, but True will be non-Zero. Therefore, you should
test as follows:-

If Nz(SLookup(.....), 0) = 0 'Testing for False
Or
If Nz(SLookup(.....), 0) <> 0 'Testing for True

HTH
Steve

 

[Guest]

Since I'm not aware of an SQL Server, I'm assuming I'm not.

 

[George Nicholson]

Instead, regardless of the checkbox, this code does nothing.

Assuming that your checkbox is bound to bShow in tShowDialogs...

Then my guess is that Dlookup is unable to find a record where BOTH
(tShowDialogs.sFormname = Startup) *AND* (tShowDialogs.sUserName =
CurrentUser). OR, if it does find a matching record, tShowDialogs.bShow for
that record is something other than True.


HTH,

 

[Guest]

There is only one record in the table, and sFormName=Startup and
sUserName=Admin, but no matter what bShow is, nothing happens. If it is
false, the code is supposed to open form Startup. If it is true, then the
code is supposed to do nothing.