Search results

Sorry, I'm new to this, including the Forum. This is actually the first time I have used a Forum for help. I was hoping the Requery would populate my List Box with CID that had a matching CType/PGCode/PDCode combination for a filter. Nothing appears when I switch from Combo to Combo. I...

Maybe if I somehow embedded the following SQL into the Row Source for the List Box it may solve all my problems: SELECT DISTINCT MasterCID.CID FROM MasterCID This should be the WHERE statement: SELECT MasterCID.CType, PGCodes.ID, PGCodes.PGCode, PDCodes.ID, PDCodes.PDCodes FROM PDCodes INNER...

I did follow your recommendations: * Remove all (not some but all) the code you have in the Got Focus event of all three combo boxes * And requery in the After Update event as advised * If Combo1 changes based on option button then you want to Requery Combo1 in the Ater Update event of the...

Combo1 does change based on Option buttons at the top. Private Sub Form_Load() 'sets the list for the first Combobox Me.Combo142.RowSource = "SELECT [CCode].[CCode] " & " FROM CCode ORDER BY CCode;" Me.Combo142.Requery End Sub Private Sub Combo142_AfterUpdate() 'Clears the second Combobox...

vbaInet: In the queries I have WHERE (((MasterCCID.CType) Like Forms![CID Gen]!CType) as a call to Combo142, which is called CType. Thanks for helping me out.

vbaInet: Is this what you mean? Private Sub PDCode_GotFocus() Me.List181.Requery End Sub Private Sub PGCode_GotFocus() Me.List181.Requery End Sub Or should I add that to the CCode Combo Box? Private Sub Form_Load() 'sets the list for the first Combobox...

Thanks but I did try that already.

I did try to break it down into a simple chunks by using a query, these two queries will give me the data I want but they don't activate automatically. I have to go into Design View on the form and then Form View and the list box will be populated. List Box Row Source: SELECT...

I did try using the Cascading Combos method without much success. :banghead:

I have a Form in Access 2003 which contains a List box which pulls ID's from the Main table for the form. What I want to do is have the three Combo boxes on the form to be the filter for the list box. I have tried several ways of getting this to work. The first ComboBox uses the following...