If I understand your situation correctly, you do not need
a subform. Is your information something like Company
Name, Street, City, State, Zip, Phone, Fax, etc.? If so,
I would suggest that you use the combo box wizard to
create an unbound combo box that will show you a list of
records from a particular field. When the wizard starts,
click the radio button at "Find a record on the form based
on a value I select" and follow the prompts. To use the
wizard, make sure the magic wand icon in the toolbox is
highlighted, click the combo box icon in the toolbox, and
click the form.
When you select a name from the list, the rest of the
record will appear. Also, when you start typing in the
box, it will try to fill it in for you.
You may place the combo box in the header or in the form.
If there is a reason to prefer one over the other, I don't
know what it is. I tend to put it in the header when
possible, but the main reason for that is that it is easy
to use a different background color to distinguish that
part of the form from the bound fields elsewhere in the
form. I also like to keep open the option of making the
header invisible, in case it is needed some day.
-----Original Message-----
I am setting up a database for my company and want to do the following:
I have a table full of company names and addresses and I
want to create a form with a text box and a sub form. When
the user types the name of a company in the text box, I
want the details for that company to appear in the sub
form below.
