troubleshooting Question

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

Avatar of conardb
conardbFlag for United States of America asked on
Microsoft Access
12 Comments1 Solution734 ViewsLast Modified:
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.
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros