General discussion
February 28, 2003 at 02:38 AM
mmzero

MSAccess: Limiting items in a dropdown.

by mmzero . Updated 23 years, 6 months ago

I’m creating a little Access app and am having trouble. I have a form that writes to an table holding info about ads running in newspapers. It has two fields, Pub and AdSize and each of these is linked to tables holding the Pub names and AdSizes.I want the AdSize dropdown to be limited to the adsizes for the particular Pub selected from the Pub dropdown. I tried a query on the AdSize dropdown properties, with criteria of Pub equal to forms!tblPub!Pub, but the query prompts me for a parameter value instead of evaluating forms@tblPub!Pub.

This discussion is locked

All Comments