NearImpossible
Registered User.
- Local time
- Today, 05:07
- Joined
- Jul 12, 2019
- Messages
- 225
Having a brain fart and can't seem to figure this one out, please point out the obvious that I am missing
my code is erroring with "Run-Time error '3075': Syntax error (missing operator) in query expression "InvoiceDetailID='23".
my code is erroring with "Run-Time error '3075': Syntax error (missing operator) in query expression "InvoiceDetailID='23".
Code:
Dim rs As Recordset
Dim s As String
Set rs = CurrentDb.OpenRecordset("Select * from [dbo_FacilityInvoiceEquipment] Where 'InvoiceDetailID ='" & Me.InvoiceDetailID & "'", dbOpenDynaset, dbSeeChanges)