We help IT Professionals succeed at work.

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

conardb
conardb asked
on
729 Views
Last Modified: 2012-05-30
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.
Comment
Watch Question

Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
<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?

Author

Commented:
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.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
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 CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
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

Author

Commented:
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.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

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


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

Author

Commented:
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 CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
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?

Author

Commented:
I think that can be a solution.
MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Yes, I can do it in this way.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.