Pulling The Last Record

[VBAmateur]

Hey I have been trying to pull a recordset from a table in my DB and then select the last record in that table but It won't happen right and pull the last one. I have been using the following:


Sql2 = ("Select * from LocationTracking Where locationtracking.AccountNum = " & "'" & txtFindAccount.Text & "'")

tb13 = db.openrecordset(sql2)

tb13.movelast

Then it pulls a account from the table that is in the middle somewhere and I need it to pull the last one. Any suggestions, Please.

[bsmith]

Add an Order By Account to your select statement after your WHERE clause.

[VBAmateur]

Thankyou Thankyou Thankyou