SQL Lookup Syntax Question

[Hack]

Alias your table names. I don't know what your table or field names are, so I just made stuff up, but try something along the lines of

sSQL = "select drsins.InsRecID, drsins.SpecID, drsins.Insurance, drsins.InsuranceID, "
sSQL = sSQL & "doctable.drid, doctable.drname, doctable.address from DrsInsuranceList drsins, "
sSQL = sSQL & "DoctorsTable doctable where drsins.SpecID like '" & Text7.Text & "'"
sSQL = sSQL & "and drsins.drid = doctable.drid"

Bear in mind this is off the top of my head, but you should get the general idea.