I'm gonna freaking scream!

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

Ok I've been building my employer a database to help manage/predict his
inventory. On the main form that i built, it has one combo box and two
subforms. The subforms contain yearly data projection and monthly
projection. I made it so that when a product is picked from the combo
box both of the subforms automatically showed that particular item.
When i came in today, I was unable to do this. The combo box still
lists all of my products, but it does not control the subforms. How do
I link them together. I've been trying to figure this out all day!

thanks in advance!

Long live the awesome answers of the Google groups.

Tracy
 
Tracy said:
Ok I've been building my employer a database to help manage/predict
his inventory. On the main form that i built, it has one combo box
and two subforms. The subforms contain yearly data projection and
monthly projection. I made it so that when a product is picked from
the combo box both of the subforms automatically showed that
particular item. When i came in today, I was unable to do this. The
combo box still lists all of my products, but it does not control the
subforms. How do I link them together. I've been trying to figure
this out all day!

thanks in advance!

Long live the awesome answers of the Google groups.

Tracy
Click to expand...

The MasterLink/ChildLink properties of the two subform controls handle this.
 
Tracy said:
Ok I've been building my employer a database to help manage/predict
his inventory. On the main form that i built, it has one combo box
and two subforms. The subforms contain yearly data projection and
monthly projection. I made it so that when a product is picked from
the combo box both of the subforms automatically showed that
particular item. When i came in today, I was unable to do this. The
combo box still lists all of my products, but it does not control the
subforms. How do I link them together. I've been trying to figure
this out all day!
Click to expand...

How were the subforms related to the combo box on the main form? Via
their Link Master Fields properties? Check those properties to see if
they've been changed or cleared. Also check the name of the combo box
to make sure it hasn't been renamed.

If you weren't using the Link Master Fields to filter the subforms, but
instead were using VBA code to modify their recordsources, check that
there is no compile error or broken reference that is preventing that
code from executing. You can check for broken references by opening the
VB Editor and clicking Tools -> References..., and checking for any
reference marked MISSING.
Long live the awesome answers of the Google groups.
Click to expand...

JSYK, the newgroups exist outside of Google. Google groups just
provides a web-based newsreader.
 
ah ha! the VB editor found MISSING. Thanks so much!!! I just fixed my
problem in about two seconds....gosh i should have went to google
groups sooner than I did. Well at least I got in a full 8 hour work day!
 
Back
Top