Combo Box Used for Selection Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I created which allows users to enter information about
certain audit procedures performed. The form header contains the audit
reference and the detailed audit procedures performed. The subform in the
detail section, is where the user enters the results of the testing
procedures. Currently, the user has to use the record navigation buttons at
the bottom of the form to locate the audit step he/she is looking for. I
have made the audit reference field in the form header a combo box, but can't
get the action working right. What I want it to do is when the user selects
a particular audit reference from the list, it displays that record in the
subform. Thanks.
 
It sounds as if you want an entry chosen in your combo box to locate records
on your form for you. If this is the case, Access should help you accomplish
this.

Try deleting the combo box and adding a new one from the Toolbox. When you
add the new box, a wizard should open asking you what you want to do. One of
the choices is "Find a record on my form based on the value I select in my
combo box". This should do what you need.
 
Back
Top