At Your Survey: Rogers Access Library Combobox

[michael.legge@rbc.com]

Hi there,



I have been working to manipulate the "At Your Survey" database from Rogers Access Library which many of you seem to be familiar with. On the Response Enter/Edit Form you can use the arrows to navigate the questions. Instead, I would like to use a combo box to navigate through these questions, bringing you to the response when selected. I have attached my file, I have already figured out how to populate the combobox with the Question variables, where i need help is applying the "find" functionality to bring me to the question variable i select in the combo box. Any help would be greatly appreciated.

Thank you!

[June7]

Controls used to input filter criteria must be UNBOUND, otherwise will change value in record.

One way to do the 'find' is with a parameterized query. Review: http://datapigtechnologies.com/flash...tomfilter.html

Other methods require more code to set Filter and FilterOn properties or use RecordsetClone and bookmarks to 'go to' the desired record.