-----Original Message-----
Linda,
Will you have a common field between the main form,
and the sub form? If so, you can use the add subform
wizard option at the top of your view design screen to add
the subform to your subform (make sure to mention during
using the wizard that you want the main form and subform
to be linked via the common field you are interested in.
If you want to use just an entry box on your main
form, and have the entry made in that box query your
information on your subform, the you should base your
subform on a query, that uses in the field being queried,
a reference to the entry text box on your main form.
In the field being queried, of the query that is being
used as a source for your subform, in the criteria area of
that field place something like the following to refer to
the entry text box on your main form.
[Forms].[mainformname].[entryboxname]
Type the [Forms] part in just the way it is, then
type in the name of your main form as above instead of the
mainformname I used, then type in the entry box name from
your main form, instead of the entryboxname I used above.
Now make sure that the query is the source of your
subform being called. You can have your button open the
subform if you would like. In your button properties you
will use a macro for the onclick property of that button,
and you will have your macro use the openform action to
open the subform. The subform will then show the records
that are related to your entry box from your main form
when the button is clicked.
I hope this information helped. It is definitely
correct information.
Have a nice day.
Bye,
Casey
-----Original Message-----
I posted this question last week. Since then I was out
sick, so if anyone answered it, I missed the answer.
Please help.
I have created an entry form for my users. I would like to
create a "subform" that will list or display all records
that partially match when the user uses the "Find Record"
button. I need help to determine the commands to use in a
query or macro.
I really appreciate the assist everyone has given me in
the past. Thanks for sharing your knowledge.
Linda
.
.
