Topic: Help with the code
There is a heap of everything, but here a piece in which it is necessary to take from the second table given corresponding to the data of the first table
' programming Sheet Dim rsLP As Recordset, myLP, S1 As String Set rsLP = CurrentDb. OpenRecordset ("select * from [Equipment ] where the Name =" and Me._) ' this line swears Do Until rsLP.EOF myLP1 = rsLP! Loops myLP2 = rsLP! Resistance rsLP.MoveNext Loop _ = "Shlejf-1 =" and asl1 and ", Shlejf-2 =" and asl2 and ", Shlejf-3 =" and asl3 and ", Shlejf-4 =" and asl4 and ", Shlejf-5 =" and asl5 and ", Shlejf-6 =" and asl6 and ", Shlejf-7 =" and asl7 and ", Shlejf-8 =" and asl8 and ", Loops -" and myLP1 and ", Soprot -" and myLP2
P.S.: the data in the field "Name" and "_" the equal
In advance thanks.