Thank you PianoMan. I used your code and am getting a "Compile error: Method or data memeber not found" on the line
Set Me.custResults. Recordset = db.OpenRecordse t(LSQL, dbOpenSnapshot)
Any idea how to fix this?
Okay, after googling the above error I changed Me.custResults. Recordset to Me!custResults. Recordset and am now getting a Run-Time error '3061' Too few parameters. Expected 1.
Also,...
User Profile
Collapse
-
VBA forms/parameters No Errors; No Results
Hello, I am trying to create a form that has multiple parameters. A user needs to enter a parameter but if one is left blank that is okay.
...Code:Private Sub DomesticQueryRun2_Click() Dim db As Database Dim Lrs As DAO.Recordset Dim LSQL As String Dim LTrackNum 'Open connection to current Access database Set db = CurrentDb() If Len(Forms![test]![TrkNbr])
No activity results to display
Show More
Leave a comment: