Avatar of conardb
conardb
Flag for United States of America asked on

Split Form not applying filter by form when combo box / fields showing non-bound field

I thought the issue witht he question / id above ID27735560 was resolved.  I updated the column width of combo boxes in layout view and when toggling to form view filter by form did work when the descriptive /non-bound field was displayed.  The filer is also being displayed in a text box and it did show that the filter was on the id field.  However, after saving and closing the database the same issue occurs.  If the non-bound field is displayed in the combo box filter by form returns type mismatch.  How can just the descriptive field be displayed and the filter be applied using the bound / id field or how can both fields be displayed in the combo box and the filter be applied using just the id field?  I tried changing the column widths to show both but only the bound column actually shows after a list item from the combo box is selected.
Microsoft Access

Avatar of undefined
Last Comment
conardb

8/22/2022 - Mon
Jeffrey Coachman

<ID27735560>
Can you post the actual link to the Q?

Again, why not just display the Bound/Key Field and a Linked "Descriptive text" in separate controls, (In addition to the combobox) then filter on the Key value control, while viewing the Descriptive text?
conardb

ASKER
conardb

ASKER
I'm doing this to enable the filtering on multiple field as desired by user... I'll try adding the descriptive text to a seperate control.  Would the descriptive control then have to update bound control and would filter by form in the sort&filter menu be able to initiate the filter?  I'd like to enable the user to filter on all or any field from one screen / on same form.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Jeffrey Coachman

FWIW.
Most systems like this (as I and mbizup sated in your previous question) use a dedicated "Filter form', where all the filtering is done.
Then based on these selections, the main form is opened Filtered for these selections.

In this way you have much more control over how the user filters.

Is using Filter by Form a deal breaker?
Jeffrey Coachman

It seems that mbizup has followed up in your previous Q with basically the same thing I am saying here, ...so you can delete this Q
conardb

ASKER
No, a form/subform combo isn't a deal breaker.... I'm dogged about it because I was able to have it work while in the form and modifying / making changes within layout view so I'm thinking there is some setting I'm missing to enable this.  After user review I'm going to need to add a filter button vs using the advanced sort / filter option and id the constraints for enabling multi-valued fields for these attributes also so significant change may be in order anyway.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jeffrey Coachman

<multi-valued fields>
This may add even more headaches...


OK, so then where do we stand on this Q?
conardb

ASKER
Yes, I can anticipate headaches with multi-valued fields.  I think an additional table / relation may be in order.  Regarding this Q, I'd like to know if / how the functionality to display the non-bound field in a combo box while enabling filtering on the bound field can be done.  I was able to accomplish it after editing in layout view but it did not remain after closing and reopening.
Jeffrey Coachman

The technique I prefer is to have one form that sets all the filtering criteria, then opens the main form filtered for those selections.
Is this what you would like?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
conardb

ASKER
I think that can be a solution.
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
conardb

ASKER
Yes, I can do it in this way.