SUBFORMS

Hi,
Pretty new at access, so may be a stupid question.
Right here goes, on a main form i have a text box and a button, when the
user enters a ID number for example 445 i have it so that a seperate
datasheet comes up to display customer name. However what i want to do is to
put the search results into a subform within the main form. So the person
enters the ID 445 and instead of a seperate datasheet coming up it is put
into the subform within the main form. Any chance anyone knows how i can do
this?

Open you main form in design view. Click on the toolbox icon - looks like
crossed hammer and wrench. It opens up a small popup window. Move the cursor
over the icons until you find the one that displays Subforms/Subreports.
Click on it and it opens another window. Select your datasheet form. Select
the field(s) for Master-Child links. These are the fields the two forms have
in common to syncronize them.
Size the subform, save, and run.

"Andy" wrote:

Hi,
Pretty new at access, so may be a stupid question.
Right here goes, on a main form i have a text box and a button, when the
user enters a ID number for example 445 i have it so that a seperate
datasheet comes up to display customer name. However what i want to do is to
put the search results into a subform within the main form. So the person
enters the ID 445 and instead of a seperate datasheet coming up it is put
into the subform within the main form. Any chance anyone knows how i can do
this?

On Fri, 17 Feb 2006 15:08:28 -0800, "Andy"
wrote:

Hi,
Pretty new at access, so may be a stupid question.
Right here goes, on a main form i have a text box and a button, when the
user enters a ID number for example 445 i have it so that a seperate
datasheet comes up to display customer name. However what i want to do is to
put the search results into a subform within the main form. So the person
enters the ID 445 and instead of a seperate datasheet coming up it is put
into the subform within the main form. Any chance anyone knows how i can do
this?

Simply put the (datasheet format) customer information Form onto the
mainform as a Subform - use the Subform tool in the toolbox or just
drag the form onto the mainform in design view. Set the ID number as
the master/child link field.

John W. Vinson[MVP]