|
-
Feb 1st, 2000, 01:37 AM
#1
Thread Starter
Lively Member
When I run the following code it is telling me I have too few parameters and I don't know what else to try. The first sql statement (sql) does work but Sql3 has 'too few parameters'. What to do?
PS See I am trying to click on a find button which pulls info from multiple tables but I cannot get it to pull info from a second table into textboxes on my form. Please Help!
Private Sub cmdGoFind_Click()
Dim db As Database
Dim tb As Recordset
Dim tb11 As Recordset
Dim tb20 As Recordset
Dim sql As String
Dim Sql2 As String
Dim SQL3 As String
Set db = DBEngine.OpenDatabase("S:\Dbapps\Repo\RepoInv", False, False)
sql = ("Select * from RepoInventory where [Account Number] = " & "'" & txtFindAccount.Text & "'")
SQL3 = ("SELECT Auctions.* FROM Auctions, RepoInventory WHERE Auctions.AuctionID = RepoInventory.AuctionID")
Set tb = db.OpenRecordset(sql)
Set tb20 = db.OpenRecordset(SQL3)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|