Bill,
There are a couple solutions. I typically don't limit the Row Source of the second combo box but sort the returned records with the acceptable values at the top and the remainder at the bottom. I will also add a column that displays a visual indicator of the not acceptable values.
For instance a continuous form for selecting a category and then product might have a productID row source like:
SELECT Products.ProductID, Products.ProductName, IIf([CategoryID]=[Forms]![frmCascading]![CategoryID]," (OK)"," (NOT)") AS Expr1
FROM Products
ORDER BY IIf([CategoryID]=[Forms]![frmCascading]![CategoryID]," (OK)"," (NOT)"), Products.ProductName;
You can add code to check the third column cboProductID.COlumn(2) to make sure it is (OK) after updating.
Duane Hookom MVP
MS Access
----------------------------------------
> From: Bill.Singer@at-group.net
>
> I have a form that has a two combo boxes. They are cascading, the second
> combo box runs off of a query. The query changes the election options in
> the second combo box based on the selection in the first combo box. During
> the initial record input the combo boxes work perfect. However, recently as
> we have to go back and view some of the records, the second combo box is not
> updating. As I scroll through the records the first combo box will update
> but the second combo box typically just goes blank. It will not update
> unless I click on it or use the refresh button in the menu.
>
>
>
> Is there a way to get the second combo box to update/refresh each time a
> record is changed. I would have typically tried to go to the form
> property "on Current" and tried to put a refresh in there but I already have
> an event in there.
>
>
>
> What is the best way to accomplish this.
>
>
>
> .as always, thanks for your wisdom.
>
>
>
> Bill Singer
>
> MN
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar