Populating combo box based on user input elsewhere

D

Doug F.

I have 3 tables, Contacts--->>PamphletOrders--->>PamphletDetails.
Form '#10 Pamphlets' has 2 subforms:
-subform #10A PamphletOrders (which has OrderType, a user input, combo box)
-subform #10B PamphletDetails (problem is the combo box here)

Problem: subform #10B PamphletDetails combo box content must change as
OrderType (in #10A) changes.
It now shows nothing, ie blank.

-subform #10B PamphletDetails record source:
SELECT [V$Pamphlets].Pamphlet FROM [V$Pamphlets] WHERE
([V$Pamphlets].OrderType)=forms![#10 Pamphlets]![subform #10A
PamphletOrders]!OrderType ORDER BY [V$Pamphlets].Pamphlet;

If I remove the WHERE statement it does show me all entries
in the lookup table V$Pamphlets. But I want to restrict the options
based on OrderType.

Thanks,
Doug
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Datasheet based on Combo Box selection 3
Subform display based on combo box choice 3
Populating a form from combo box 3
Subform User Input 0
Automatically generating text entries from combo box 4
Changing the combo box based on the entries in previous records 1
Filtering a combo box on a subform using a value from the main for 3
requery a combo box that is based on a query 0

Top