Cliff67
Registered User.
- Local time
- Today, 07:41
- Joined
- Oct 16, 2018
- Messages
- 175
Hi Everyone
I've got a module that populates several date boxes on a form based on the history table. Not difficult I hear you say...However I just can't see what I'm doing wrong I keep getting an error saying Too Few parameters
Here the code I'm using to find the dates
Set rs = db.OpenRecordset("Select * from Tbl_Tickets_History where TSNo = " & Me.Ticket_Number & " AND Status = " & "'First Contact'")
So I'm opening a recordset based on the TSno on the form and looking for all "First Contact"s within the status.
I just can't see what I'm doing wrong :banghead:
Any help would be much appreciated
Cliff
I've got a module that populates several date boxes on a form based on the history table. Not difficult I hear you say...However I just can't see what I'm doing wrong I keep getting an error saying Too Few parameters
Here the code I'm using to find the dates
Set rs = db.OpenRecordset("Select * from Tbl_Tickets_History where TSNo = " & Me.Ticket_Number & " AND Status = " & "'First Contact'")
So I'm opening a recordset based on the TSno on the form and looking for all "First Contact"s within the status.
I just can't see what I'm doing wrong :banghead:
Any help would be much appreciated
Cliff