Yes, you should be able to do that. Just ensure that the ColumnCount is 3, and that ColumnWidth value is 0 for the column you wish to hide.


>
>I have a question for you concerning my office search form I created last week. Everything works perfect, but I think I want to change the way I "reference" the combo boxes.
>
>Let me explain:
>
>The way I have it set up now, I am referencing names and not numbers. I believe I want to reference numbers, because it is better database design.
>
>My p-view for my county combo box is currently:
>
>WHERE counties.cjurisstate = ?THISFORM.CurrentState
>
>&& When, the user selects FL in state combo box, any record in the county combo box that has FL in it, gets pulled. Which is great.
>
>In addition, for my locality (city) combo box, my where statement for my p-view is:
>
>WHERE locality_subordinate.cjurisstate = ?THISFORM.CurrentState AND ;
>locality_subordinate.cjurisname_b = ?THISFORM.CurrentCounty
>
>&& this works perfect as well. Anytime a user selects a county in the county combo, any record in the city combo with the same county gets pulled.
>
>_____________________
>
>My concern is when I get to my last combo box, which is actually pulling office titles.
>
>I want to be able to reference id numbers and not text.
>
>I have a field that is the link for everything. Each one of my views / p-views created for this office search form has it. The field is:
>
>njurisid
>
>
>My question is this:
>
>How can I still use this number and have the text I want still show up in the combo boxes? I can't use the combo box builder, b/c I am using p-views. So, I need to use the property box.
>
>Currently, for my states view, attached to my state combo box (combo box #1), I have placed in my row source:
>
>states.cjurisstate, cjurisname
>
>I have this set to:
>
>Bound = 1
>
>Can I change that to:
>
>states.cjurisstate, cjurisname, njurisid
>
>and hide the last field (njurisid), but still have that be used as the reference? I still want cjurisstate field placed into the text box, but I want the WHERE statement in my p-view to refer to the njurisid.
>
>
>The same goes for the next combo box (county)
>
>Currently, in the row source of that combo box, I have:
>
>county_search_pview.cjurisname_b
>
>I would like to have that changed to:
>
>county_search_pview.cjurisname_b, njurisid
>
>Can I do that and reference the njurisid, and still have the cjurisname_b placed into the combo box?
>
>TIA for any commments
>
>jason