This might be a shot in the dark, but is there a way for me to speed up this snippet of code? Even a second would count, as this code gets called repeatedly.
Code:
Me.RecordSource = "SELECT * FROM [" & tbl_task_table & "] where [Task ID] = " & curw_rs.Fields(1).value & ";"[code]
I tried to select directly from the table itself as opposed to accessing it through the record set's name propety. Turns out that was even slower.