Unbound Combo Boxes

P

P98

Here is my scenario

4 Tables
Call
Call Types
Call Sub Types
Call Type Sub Type Xrefs

What I am trying to do...

On the form for calls I am trying to store the Call Type Sub Type Xref Id by
selecting a Call Type and Call Sub Type. THis part I have accomplished by
using an Unbound Column and using the record source of Call Types and another
ComboBox bound to the Xref Id in the Call Table with the record source being
a query with Call Type Xref Table and Call Sub Types with the text showing as
the Call Sub Type Code.

This works..what I need to to do and is not working is the following...

I want the unbound Call Type combobox to show the the Call Type Code for the
records already inserted. I don't know how to do this, and am getting
frusterated and about to scrap the Xref Table.

Any help would be appreciated..
 
Top