We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Access 2007: Query as record source for form shows 1/1 records and any data entered is as a new entry rather than working with previous values from combo box selection

Bevos
Bevos asked
on
Medium Priority
351 Views
Last Modified: 2012-06-22
Hello, I have a form called frmDecisionTree that some users here have helped me with, but it has a problem.  The form is intended to work with qryDecisionTree as the record source and already have entries present.  The user will use a combo box to select the appropriate record and then move through the check boxes on the form.  However, the form always shows 1/1 records (although the query which is the record source has 10 or so entries) and when I select a record from the combo box control it does not move to that item.  Could anyone please take a look and let me know how to fix this issue?

Thank you so much,
Bevo
EE-example-2-.accdb
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Sometimes it is impossible to find reason :(
I've created new form (frmDecisionTree1) and it is working. Filtering on Call number was also added
EE-example-2-.accdb
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks als :) this is great!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*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.