I have a procedure that goes like this:
Private Sub Form_Current()
Dim strSQL1 As String
strSQL1 = "Select Price_Year_Name from Price_Year where Category_ID = 1
And By_Default <> 0"
' I know that the result of the above query is 'Price_2003'
' I want to use the result of this query in RECORDSource property.
' How do I accomplish this?
Me.RecordSource = "Price_2003 "...
1 result in 0.0014 seconds.