creating subform from table

[Completing info from table to subform]

I somehow lost my original subform entered into my main form one day and have
been trying to figure out how to get it back. I have three years worth of
information in two tables that I need to put in this subform. What I need in
this subform is a vendor's booth space location, date paid, amt, ck or cash,
and year participated. I actually have all this information in one table,
but for some reason, my subform is only pulling up the information for my
2008 vendors. How can I get the previous years' info to show up also?
Example: John Doe should be showing info from years 2005 through 2008 and is
only showing 2008 info, but 2005, 2006 and 2007 info is in the same table of
source. What am I doing wrong here? I am new to subforms, by the way.
Thank you for your help.

 

[Jeanette Cunningham]

A subform can be opened as a form from the database window, when the parent
form is closed.
So open your subform by itself while its parent form is closed.
Now you can see if the subform will show the records for all the years, or
just 2008.

If it just shows for 2008, have a look at the record source and the filter
for the subform to see how they may be filtering out the records from the
other years.

If the subform shows records for all years when opened by itself, but not
when opened as a subform on the parent form, then look for the reason in the
way the parent form and the subform are linked, or the way their record
source is changed from code or the way that the parent form restricts the
records to the ones for 2008.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Completing info from table to subform" <Completing info from table to
(e-mail address removed)> wrote in message
news:[email protected]...