Link to home
Start Free TrialLog in
Avatar of conardb
conardbFlag 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.
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

<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?
Avatar of conardb

ASKER

Avatar of 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.
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?
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
Avatar of 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.
<multi-valued fields>
This may add even more headaches...


OK, so then where do we stand on this Q?
Avatar of 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.
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?
Avatar of conardb

ASKER

I think that can be a solution.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of conardb

ASKER

Yes, I can do it in this way.