I have a DB Lookup combo box on a form based on a small lookup table with two columns:
VRSystem VRDescription A Alignment B Brakes C Cooling E Electrical F Fuel I Inspections K Transmission L Labor M Motor/Drive train O Other Miscellaneous P Preventive Maintenance Q LOF S Suspension T Tires W Towing X Exhaust The combo box displays both columns, in order by the VRSystem Code - as shown above. The user would like the Q LOF row to be the default when the combo box opens. I can auto open the box using the LISTOPEN property. I can make Q LOF the default by adding a SORT column to the table and sorting so that Q LOF appears first. BUT - is there a way to KEEP the order above and using PROPERTY make the combo box open with focus on this row in the MIDDLE of the list? I see such a property under DB User Defined List Box in RDOCS: PROPERTY <Component ID> SELECT 'value' "Can be used to highlight/select the specified item. (WRITEONLY, no support for GETPROPERTY). Example: PROPERTY <ListBoxComponentID> SELECT 6 Will highlight/select item number 6 in ListBox" But I don't see anything like this either in DB Lookup Combo Box or DB User Defined Combo Box. The user wants a combo box here. Ideas? Or is this just the way it is for now? David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261
