>Hello everybody -
>
>I am building a search form that has 5 combo boxes on it:
>
>COUNTRY
>STATE
>COUNTY
>CITY/LOCALITY
>OFFICE
>
>I was able to create p-views and place code into the interactivechange event of the combo boxes to get this to work just the way I want it to. No problem!
>
>However, everything was referencing a name/text. I decided to go back and do it all over again, but reference the id number attached to each name.
>
>Example:
>
>My state combo box previously had>
>
>Florida
>Alabama
>
>to choose from. The field name was cjurisdiction name.
>
>My row source for this combo box looked like:
>
>state_search_pview.cjurisname
>
>So, in my ineractivechange event for this combo, I had
>THISFORM.CurrentState = THIS.Value
>etc.
>etc.
>etc.
>
>Well, THIS.Value refered to anything pulled up into the combo box, the next combo box would look at, and only pull those counties which had FLORIDA.
>
>NOW, I want to have
>
>FLORIDA, 1
>ALABAMA, 2
>
>My row source for my states combo box would now look like:
>
>state_search_pview.cjurisname, njurisid
>
>
>**** I want to have the cjurisname placed into the text box, but make everything work off the njurisid. I want to counties combo box to pull all counties based on njurisid, not cjurisname.
>
>Is this just a simple matter of making sure my property
>BOUND = 2 (so that the second column of the combo box is the on the code is looking at to pull data, but the cjurisname (state name) is placed into the textbox of the combo box?????
>
>Am I in big trouble here?
>
>TIA for any comments

Jason,
You are not in big trouble, just keep Combo.BoundColumn=2, exactly as you said.