>>>I have one form for data entry "Data Entry Form" and another form for select a record from a table "Select Form". After I select a record on "Select Form" I need return some information from the record to the "Data Entry Form". When I referenced with FormSetName.FormName.TxtName.Value = ThisTable.FieldName. I got an error message saying that "FormSetName is not an object". Did I miss anything and how should I get around with this?
>>>
>>>Jim S
>>
>>If both forms are parts of the same Formset, you should use Thisformset reference.
>
>Both forms are not within the same FormSet.
If you make reference outside formset, you should either use its physical name (of SCX file) or alias specified under NAME clause of DO FORM command. BTW, it would be much nicer to use both forms within one formset (anyway you have it already). HTH.
Edward Pikman
Independent Consultant