>I have ComboBox problems.
>
>I have a SUPPLIER table and a CODES table.
>The CODES table can have different types of codes, examples:
>
>Code_type Code_ID Code_Description
>
>TEL OFF Office phone
>TEL RES Residence phone
>TEL FAX Fax
>TER 10 Payment terms: Net 10 days
>TER COD Payment cash on delivery
>TIT PRE President
>TIT VP Vice President
>TIT SM Sale Manager
>
>I want a combobox for 3 SUPPLIER fields on the form:
>supplier.Telephone_type
>supplier.Payment_terms
>supplier.Title
>
>Now how do I get ONLY the TIT items in the combobox for the Title. I also want the form to point and show the proper CODES.Code_ID and CODES.Code_description field when I go from one record to the next.
>
>Please if someone could give me some code examples I would appreciate it.
>
>Thanks in Advance.

Hi, Raymond: I do this for lookups also. I populate each combobox with an array which has just the values for the appropriate Code_Type. Depending on the number of arrays and how many forms they're used in, you can make them global (easily accessed, but memory intensive) by running a program which scans the table and makes an array for each code_type. Alternatively, you can initiate just the ones you need for each form (adds to form loading, as you need to get the array and then store it to a form property).

HTH
Barbara