SubForm Filter Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form (frmInventorySub) that shows inventory info based on StandID in
the parent form.

I put a text box in the header of the subform where a user can enter a year
and filter the inventory records based on the year.

The text box and the associated code works great when I pull up the subform
by itself; however when embedded in the subform, it does not work at all. In
fact, not only does it show no records in the subform, but it also fields go
blank in the parent form.

Any ideas?

Thanks,
Brent
 
Brent,
The text box and the associated code works great
Click to expand...
Care to share that code with us?
however when embedded in the subform, it does not work at all.
Click to expand...
Do you mean it works when just opening the subform itself,
but not when the subform is part of a Main form?

Sounds like your not "addressing" the subform properly (when it's on the
Main form) in your code, but without the code there's no way to tell for
sure.

hth
Al Camp
 
Back
Top