Is it possible to Merge the 2 queries below in to one querie.


strSQL = "Select * From CALIBRECORDS where InstrumenNumber = " & "'" & Form1.Text2.Text & "'"




strSQLq = "Select Instrumentdescription From Guages where InstrumenNumber = " & "'" & Form3.Text49.Text & "'"

i have 2 fields in 2 diferent tables that i would like to have on one form.

Any help would be appreciated