Dreamweaver
Well-known member
- Local time
- Today, 13:14
- Joined
- Nov 28, 2005
- Messages
- 2,466
I learnt from a lot of access books but they never told me this
Set Invo = Db.OpenRecordset("OtblInvoicesLineItems'", dbOpenDynaset)
But thinking about it all these years later after it being pointed out i can see it should have been
Set Invo = Db.OpenRecordset("SELECT * FROM OtblInvoicesLineItems WHERE [InvoiceID]='INV'", dbOpenDynaset) 'UPDATED 10/11/2018
yes InvoiceID is a text value
Set Invo = Db.OpenRecordset("OtblInvoicesLineItems'", dbOpenDynaset)
But thinking about it all these years later after it being pointed out i can see it should have been
Set Invo = Db.OpenRecordset("SELECT * FROM OtblInvoicesLineItems WHERE [InvoiceID]='INV'", dbOpenDynaset) 'UPDATED 10/11/2018
yes InvoiceID is a text value
Last edited: