Combo Box with Text Box

[alexisa]

Hi everyone,
I am new and learning. I have not started on any newer versions of Access. I am on 2002, but I think that 2003 and 2007(which I have penciled to start on pretty soon) are very similar in relation to my question.
Here it goes:
I have a ComboBox which drops down with a list of categories. Let's say: Classic Audio and Vintage Amps. (The combo box works, as I can send the category items to a form in datasheet view etc.)


I also have a TextBox which is bound to the "ItemID#" (auto number) for the items that are included in each category, then a TextBox which holds the item description. I also have a "Next Record" button.
What I am trying to do is this. When I select a category from the drop down box, I would like to have the first item on the list of items contained in the category selected, populate the Textboxes with the "ItemID#" and the corresponding description of the FIRST item of the category selected with the lowest ItemID#. Then when I click on the "Next Record" button to have the TextBox and Description updated with the next record, in ascending order (by ItemID#).
The ItemID# may or may not be in sequence.
I hope this all makes sense.
Cheers!

[ranman256]

Can't you just make a continuous form sorting ITEMID asc.
then when you pick the combo item , filter on the records.

Sub cboBox_afterupdate
   Me.filter ="[field]='" & cboBox & "'"
   Me.filterOn= true
end sub

[alexisa]

Thank you for taking the time. I am 100% sure of what you mean but I'll play with and see where I get.