I have been trying to get this to work for days: When I set this SQL to open in the tb13 recordset below and then later to fill in textboxes that come from the LocationTracking table it is telling me
"Too Few Paramters. Expected 1."
Any Help:

Sql2 = ("Select * from LocationTracking, RepoInventory Where locationtracking.AccountNumber = Repoinventory.accountnumber and repoinventory.accountnumber = '" & txtFindAccount.Text & "'")

Set tb13 = db.OpenRecordset(Sql2)