Filtered Combo Boxes

[Mark Baker]

I have several filtered combo boxes on a subform. These work fine whee I
open the subform directly and test them. However, once I open my main form
(that contains the subform) and test the subform it doesn't appear to
complete the requery command.

How can I get this to work?

 

[Jeff Boyce]

Mark

When you embed a subform in a main form, you will need to tell it where to
look. It isn't looking in the stand-alone version any more, but in the
embedded copy. The syntax looks something like:

Forms!YourMainForm!YourSubformControlName.Form!YourControlNameInSubform

Check Access HELP for "Expressions"

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Larry Daugherty]

There's also some pretty good help on www.mvps.org/access contributed
by Keri Hardwicke about Form/Subform referencing.

HTH

 

[Mark Baker]

Thanks, I've got it working...although I did miss changing the path for the
criteria in my query for a little while.

Cheers