G
Guest
Hi, I want to build a Select sentence with a LIKE "PartOrACode*" option but I
dont know where to put the "*", the key field is txt and the sentence I have
is :
Sql = "SELECT tblComputers.AssetTag, tblComputers.ManufacturerID,
tblComputers.DateReceived, tblComputers.PurchasePrice, tblComputers.Warranty,
tblComputers.EmployeeID " & _
"FROM tblComputers WHERE AssetTag LIKE """ &
[Forms]![frmComputers]![Text12] & """"
Forms!frmComputers.RecordSource = Sql
Thanks
dont know where to put the "*", the key field is txt and the sentence I have
is :
Sql = "SELECT tblComputers.AssetTag, tblComputers.ManufacturerID,
tblComputers.DateReceived, tblComputers.PurchasePrice, tblComputers.Warranty,
tblComputers.EmployeeID " & _
"FROM tblComputers WHERE AssetTag LIKE """ &
[Forms]![frmComputers]![Text12] & """"
Forms!frmComputers.RecordSource = Sql
Thanks