Solved Dlookup with spaces in column names

[murray83]

Hi All

have been give the task of marinating a database but the column names have spaces and I don't want to change them as It may effect other parts of the DB

but I have a dlookup that I would like/need to add but it just comes back with the ol #error

here is my code

=DLookUp("[Supplier Name]","tblSupplierDetails","[Supplier Alpha Number]= Forms![frmComplianceFailureDataEntry]!'Supplier Number'")

any help on how to fix this with out breaking the DB would be great

cheers

 

[arnelgp]

=DLookUp("[Supplier Name]","tblSupplierDetails","[Supplier Alpha Number]= Forms![frmComplianceFailureDataEntry]![Supplier Number]")

=DLookUp("[Supplier Name]","tblSupplierDetails","[Supplier Alpha Number]= '" & Forms![frmComplianceFailureDataEntry]![Supplier Number] & "'")

 

[gemma-the-husky]

is [supplier alpha number] (and therefore [supplier number]) really a number, or is it a string? That will also affect the dlookup syntax as well

 

[murray83]

it be a string

I tried the first one and now I have a flashing #error

the second one says #name

 

[arnelgp]

bring the form, frmComplianceFailureDataEntry, in Design view and check the textbox Name.
substitute the textbox name to "Supplier Number" on the second code i gave.

 

[murray83]

huh,

what do you mean check and substitute, if your asking if they are spelled the same then yes they are

 

[arnelgp]

is it a textbox/combobox or Label ?

 

[murray83]

cheers the code did work it was my fault, bangs head.

was trying it on a copy of the form and hence the name for the form wasn't the same

cheers all