VBA Varriable in Select statement

[marrett]

Hi
I Have the following statement and I cannot get it to work.

Set Rec = DB.OpenRecordset("Select * From [Loan_Tbl]where Loan ID = Loan")


Can I use a varriable to selct form a table.

Thnaks,

Maria

 

[kal-el]

If Loan is the variable then try: -

Set Rec = DB.OpenRecordset("Select * From [Loan_Tbl] where LoanID = " & Loan)

 

[marrett]

Thanks! I have another question if you would nnot mind

Can I use more than one variable?
Set Rec = DB.OpenRecordset("Select * From [Loan_Tbl] where [Loan ID] = " & Loan) and where [loan date ] =dateofloan

Thanks,

Maria

PS do you know of any book I can buy where I could look up this stuff myself. I learned access by myself and I am very good at a lot of it, but I could be much better with the right book.

Thanks

 

[simongallop]

Don't know of book but code ought to be

Set Rec = DB.OpenRecordset("Select * From [Loan_Tbl] where [Loan ID] = " & Loan & " and where [loan date ] = " & dateofloan)