X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Cascading Combo Box On Continious Form Displays Incorrect Data, Access 2013    
post Sep 10 2019, 09:56 PM

Posts: 739
Joined: 29-May 07
From: West Virginia, United States

Hello, I have a continuous subform that has two combo boxes. The first is just a combobox (cboComponent) that I make a selection then the second combo (cboComponentParts) is based on the first. For the Row Source of the second combo I am using.

SELECT tbluComponentData.Part, tbluComponentData.IsInactive
FROM tbluComponentData INNER JOIN tbl_Components ON tbluComponentData.Component = tbl_Components.Component
WHERE (((tbl_Components.ComponentID)=[Forms]![frm_UpdateProductComponentsParts]![sfrm_UpdateProductComponentsParts].[Form]![cboComponent]))
GROUP BY tbluComponentData.Part, tbluComponentData.IsInactive
HAVING (((tbluComponentData.IsInactive)=False));

Now, here is what happens. In the continuous forms first record I select a (cboComponent) and then the (cboComponentParts) populates that correct data so I go to record two and do the same thing and it works correctly. Now here is where it gets messed up, if I decide I want to change just the (cboComponentParts) from the first record it displays the data that would be for the second record and the only way to get it to change is if I change the (cboComponent) then the (cboComponentParts) will again display the correct data.

Now here is something else, I created a query (Query1) with the exact SQL from above and then opened the form and its subform and clicked on a record and then opened the Query1 and it always displayed the correct data but the combo box didn't?

What do I need to do to fix this? Thannks!
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    21st October 2019 - 10:41 PM