Can someone just point me to a simple VBA example of a combobox with list values that filter a form on the value selected in the combobox.
The combobox is on the form its suppoused to filter
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I need to populate a combobox filter on a subform based on what is selected on a filter combobox on my mainform but no matter what I try I can't seem to get this to work.
I can populate the combobox filter on the subform using a normal combobox on that same form but can't populate the combobox filter on the subform using the filter on the main form.
I am aware that there is different syntax used to access a control on a subform and am 100% sure my syntax is perfect.
Is it possible to change the row source of the subform combo based on what is clicked on in the mainform combobox filter? I also want to be able to clear the combo's rowsource completely - when add new record is clicked.
All I want is to select a customer from the combobox, click the cmd button(CustomerSearchCommand) and have the report (CustomerSearchRa) filter the report to the value in the combobox(combo5)
In trying different things I've gotten confused on what my original code was for this command button.
Private Sub Combo9_AfterUpdate()
Form.filter = "RepairID = '" & Me.Combo9.Value & "'"
Form.FilterOn = True
There's something wrong, the filter did not work.
Could somebody give me some suggestion?
My Form is: frmReview
My ComboBox is: cmbGLimpact
The RowSource is: SELECT DISTINCT [GLimpact] FROM Initiatives UNION SELECT Null As AllChoice FROM Initiatives ORDER BY [GLimpact] DESC;
The Query Criteria is: [Forms]![frmReview]![GLimpact]
The field values are: Yes, No & TBD
The filter works fine for Yes, No & TBD, but the blank choice doesn't return all records.
I need to be able to setup several filter ComboBoxes to enable filtering on several different fields. So, depending on which ComboBox filter (field) the user wants to filter on, the otherswill allow all records to be returned.
I would like a combobox Manufacturer that would filter a Products combobox that would in turn filter a Brands combobox. After selecting a Brand from the Brand combobox, I need to enter several Varieties for each Brand and several Sizes (Size, Unit, Pkg) for each Variety.
The combobox filter does not work in View mode though - is there any way to fix this?
I have read numerous topics on this site relating to this topic and I have tried all the responses but I just keeping getting lost in the middle of the