Can someone rescue me! - 4 days of trying everything and everywhere but defeated at last.
Me.RecordSource = "select * from [tblLVRStatements] where [tblLVRStatements]![clientID] = " & clientIDVar & "ORDER BY [tblLVRStatements]![NumberStatement]"
Above is just one of my many attempts! not to work....
I have a table; tblLVRStatements.
I have an ID for the client; clientID and have a variable;clientIDVar as an identifier.
I have Statements which are in order in the table and wish to display these in the order (from NumberStatement field) in which they appear in the table BUT they display in random order with the following code;
< Me.RecordSource = "select * from [tblLVRStatements] where [tblLVRStatements]![clientID] = " & clientIDVar
Me.OrderBy = Me.[NumberStatement]
Me.OrderByOn = True >
I thought to try and order them with the SQL ORDER BY but my syntax is 'up the spout'! Please!!!!!
Me.RecordSource = "select * from [tblLVRStatements] where [tblLVRStatements]![clientID] = " & clientIDVar & "ORDER BY [tblLVRStatements]![NumberStatement]"
Above is just one of my many attempts! not to work....
I have a table; tblLVRStatements.
I have an ID for the client; clientID and have a variable;clientIDVar as an identifier.
I have Statements which are in order in the table and wish to display these in the order (from NumberStatement field) in which they appear in the table BUT they display in random order with the following code;
< Me.RecordSource = "select * from [tblLVRStatements] where [tblLVRStatements]![clientID] = " & clientIDVar
Me.OrderBy = Me.[NumberStatement]
Me.OrderByOn = True >
I thought to try and order them with the SQL ORDER BY but my syntax is 'up the spout'! Please!!!!!

Last edited: