Software

Ask something
Discussion Locked

MSAccess: Limiting items in a dropdown.

0 helpful
1 reply

by mmzero

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

1 reply

by bristar

You will probably need to create some VB to run when you select a pub size that will load an SQL statement to declare the source of the AdSizes box.

This discussion is closed to new replies.