Jumping to a page instead of scrolling by primary keys

[wazawak]

I have a form that displays the product line, model number, list price, and invoice price of a particular product, all of which can be edited on the form (see attached screenshot). However, the problem is that the only way to go from one product to another is by scrolling one by one through the ProductIDs, which are just the primary keys and are in no order other than the order they were inputted in.

Obviously this will create problems once I start populating this with data and it starts being used. What I would like to do is create a way to select the product page to jump to by using some kind of dropdown menu, preferably alphabetized. How can I go about doing this?

 

[wazz]

the way it is now you'll have to go with ModelNumber.
- create a query that lists the productid and model number (modelnumber asc)
- add a combobox (unbound) to the form and use the query as the record source
- name the cbobox cboSelect (or similar); two columns, hide the first column
- in the afterupdate event of the cbobox put

me.recordset.findfirst "productid = " & me.cboSelect

 

[wazawak]

By "Record Source" do you mean "Control Source"?

 

[wazz]

i meant row source; the control is unbound so you're supplying a separate data/row source independent of the form.