SQL and recordset Problem

[VBAmateur]

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)

[Serge]

It can mean that you misspelled field name or a table name or didn't pass the value for your parameter, which is impossible in you case, because you're not using stored procedures or compiled queries. Check field and table names in your SQL Statement.

------------------

Serge

Senior Programmer Analyst
[email protected]
[email protected]
ICQ#: 51055819

[kameni]

Maybe it is happening because you forgot to put ; sign at the end of your query. I mean:

Sql2 = ("...'" & txtFindAccount.Text & "';")

------------------
Kameni