ComboBox With Multiple Field Primary Key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 2 combo boxs.... 1 works find and the other displays a blank. The form uses all locked fields and is used as an inquiry. The main table used in the form has the 1 field used in the 1st table and the 3 fields used on the second example

The one that work lookups a name on a table based on a single field ID key. ControlSource has that field in the property list. This one works fine

The 2nd one is using a table that has a primary that is made of 3 fields... (1 text and 2 numeric). What do I put in the control source? The Drop down shows the correct values but the box is empty when closed. I have tried each of the 3, I have tried connecting them with a & or a +.
 
I had a similar situation. I finally got it to work by running a seperat
query with those three fields and cancatenated 2 of them. I chose th
non cancatenated field as the bound column as well as the contro
source and it worked. I tried several other options including cancatenatin
the fields in a query with my other form information. However, it onl
worked when I placed the combo box fields in their own query wit
cancatenation of two of the three. I hope that helps you. Good luck!
 
Back
Top