Tabs and Viewing All Records

[Jennifer Cali]

I have two forms - frmRecipes and subRecipesAll. In the frmRecipes, I used
the tab tool to create two tabs on the form. The first tab shows each
individual recipe with all the fields in the tblRecipes reflected. The second
tab is (supposed) to be the subRecipesAll, which is a form I created in a
continuous format so that all recipes show up as individual "rows". If I open
the subRecipesAll form on its own, then it correctly shows all recipes, one
per line, with the selected fields showing on that corresponding line. If I
drag & drop the subRecipesAll form into the second tab of the frmRecipes,
though, it seems to be filtering and only showing the record that corresponds
to the record showing on tab one. I hope that makes sense. Any advice on how
I can make ALL the records show up on the second tab like it does when I open
it on its own?

 

[Wolfgang Kais]

Hello Jennifer.

I have two forms - frmRecipes and subRecipesAll. In the frmRecipes,
I used the tab tool to create two tabs on the form. The first tab shows
each individual recipe with all the fields in the tblRecipes reflected.
The second tab is (supposed) to be the subRecipesAll, which is a form
I created in a continuous format so that all recipes show up as
individual "rows". If I open the subRecipesAll form on its own, then it
correctly shows all recipes, one per line, with the selected fields
showing on that corresponding line. If I drag & drop the subRecipesAll
form into the second tab of the frmRecipes, though, it seems to be
filtering and only showing the record that corresponds to the record
showing on tab one. I hope that makes sense.

Yes, it does. The subform was linked to the master form automatically.

Any advice on how I can make ALL the records show up on the
second tab like it does when I open it on its own?

Select the subform control on tab 2 and clear the LinkChildFields and
LinkMasterFields properties using the properties window.

 

[Jennifer Cali]

You are wonderful - that solved my problem. Thanks!