Look at the following code please:
Form1.Data1.Recordset.FindFirst Form1.Text1.DataField & " = '" & "First Value" & "'"
The above statement works well, but I would prefer to use a variable for .Data1. and also .Text1. but I don't know how to get variables into that command string and have it evaluate without and error.
Thanks in advance.