After Upsize to SQL Server SQL code from VBA no longer works

[DomDom3]

Hi there,

The following code worked perfectly well with Access;

Forms![frmdeleteProject]![sfrmAddRemoveRecord].Form![CustomerDelete] = DLookup("[Customer name]", "[tblOSPWithAllAddedFields]", "Forms![frmdeleteProject]![sfrmAddRemoveRecord]!Form![UniqueIDdelete]=[tblOSPWithAllAddedFields]![Unique ID]")

after upsizing, I get a syntax error pointing to

Forms![frmdeleteProject]![sfrmAddRemoveRecord]!Form![UniqueIDdelete]=[tblOSPWithAllAddedFields]![Unique ID]"

Can anyone tell why?

Thanks

 

[Remou]

Try:

DLookup("[Customer name]", "[tblOSPWithAllAddedFields]", "[tblOSPWithAllAddedFields]![Unique ID]=" & Forms![frmdeleteProject]![sfrmAddRemoveRecord].Form![UniqueIDdelete]

Assuming that the ID field is numeric.

 

[DomDom3]

Thanks for your suggestion, it didn't quite work but gave me the inspiration to try

Forms![frmdeleteProject]![sfrmAddRemoveRecord].Form![CustomerDelete] = DLookup("[Customer name]", "[tblOSPWithAllAddedFields]", Forms![frmdeleteProject]![sfrmAddRemoveRecord].Form![UniqueIDDelete] & " =[tblOSPWithAllAddedFields].[Unique ID]")

and it worked - thanks for yor help.