Hi Guys
Hi Guys
I have a form for my asset database that populates the name of the asset from active directory and compares that name against a table called "assets" then pulls in all the support requests listed against it.
the code below works really well
Me.Text26 = DLookup("[AssetID]", "Asset", "[AssetName]= '" & [DomainComputerName] & "'")
what I can't do is this
I need to be able to dispose of each asset when they have reached their end of life, the replacement assets will have the same name as the asset we just disposed of.
I have a field in the asset table called "assetdisposedof" that's a yes/no field. what I need to be able to do is amend the lookup to include [assetdisposedof]=false" in the above.
Me.Text26 = DLookup("[AssetID]", "Asset", "[AssetName]= '" & [DomainComputerName] & "'" & "[assetdisposedof]=false") produces "syntax error (missing operator) I can't get my head around how to only lookup names that are set to false.
Many Thanks
Steve