dlookup syntax

[markjkubicki]

ok... its getting late, I'm tired...
I'm sure it will be obvious, but I just don't see the error

=DLookUp([tbeSubIssueSchedule_Types]![type],[tbeSubIssueSchedule_Types],[Type]="""&[Forms]![frmSpec]![txtType]&""")

where


[type] is a valid string field in the valid table [tbeSubIssueSchedule_Types] (yes, I know "type" is not a good name... but I inherited it)
and the expression [Forms]![frmSpec]![txtType] generates a valid string response

-------
ultimately, I'm looking to include it in the control source for a checkbox (it's complicated why...)
the control source would be =
iff(isnull(DLookUp([tbeSubIssueSchedule_Types]![type],[tbeSubIssueSchedule_Types],[Type]="""&[Forms]![frmSpec]![txtType]&""")),false,true)
does that seem right to you too?

many thanks in advance,
Mark

[June7]

Arguments must be within quote marks, unless they are variables.

=DLookUp("[Type]", "[tbeSubIssueSchedule_Types]", "[Type]='" & [Forms]![frmSpec]![txtType] & "'")

Why are you looking up Type when you already have Type?

[markjkubicki]

you actually noted a different problem... there are (2) criteria that need to be met

=DLookUp("[Type]","[tbeSubIssueSchedule_Types]","[Type]='" & [Forms]![frmSpec]![txtType] & "'" And "[SubIssueTitle]='" & [me].[txtSubIssueTitle] & "'")

here's the bigger mess
I have a table of Lamp_Types (or whatever)
and I need to be able to filter the report of Types based on whether or not they are included in an order
on the same form that the Types are entered is a subform with a list of all the orders that exist onto which they COULD be added
also on that subform, next to each order is a checkbox - if the record is already included, it will be checked, if not...

if the user clicks the checkbox, code will check to see if the record is already in a table that incudes a list of Types and what orders they are included in (it is related to the table of LampTypes and a table of Orders
... code will them delete the Type from the table if it is already there, or add it if it is not, and then requery the subtable

complicated -yes? (but I can't think of a way around it -UGH)

[June7]

Correct syntax for the DLookup is:

DLookUp("[Type]", "[tbeSubIssueSchedule_Types]", "[Type]='" & [Forms]![frmSpec]![txtType] & "' And [SubIssueTitle]='" & Me.[txtSubIssueTitle] & "'")