code in subreport can't find table

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

Guest

I have a form that has a couple drop down lists and one drop down that uses
the results of a query for it's choices (for example if I chose "Fruit" in
one drop down, the next one would list only types of fruit but not meats or
vegetables). This form works fine alone.

When I insert this as a subreport, put some simple VB code to requery the
options for the drop down, and then run it, I get an error. The error states
that the table (the one that works fine alone) can not be found.

The code is right, but apparently I'm missing something using this type of
drop down/subreport. Any thoughts? Thanks.
 
Back
Top