> 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?
Use the NAME clause when calling the forms. This will create a memvar
of that name when the form is invoked, and the form will be bound to
that memvar. You will then be able to say:
m.FormName.TxtName.Value = ThisTable.FieldName
or:
release m.FormName
... to make the form go away.
If you take this to the next step, you can have an array of the forms,
and initialize each form to the next element in the array. But I'll
leave the rest of that to you.
/Paul