Combi Boxes

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

Guest

Please can you help me as in a form I trying to Link a Purchase number in a
comi box to automatically populate another to text or Combi box to the Item.
For example

Purchase Number: 3333333 would automatically add Item: Pencil to another
text or combi box
 
Please can you help me as in a form I trying to Link a Purchase number in a
comi box to automatically populate another to text or Combi box to the Item.
For example

Purchase Number: 3333333 would automatically add Item: Pencil to another
text or combi box
Click to expand...

I dont really see why you would need it to populate the same data into
another box? unless you have a specific need. i am assuming that the purchase
number is the key and item is the 2nd field.

In the underlying query for the combo box you could simply select both the
purchase number and the item. Then for the settings of the combo box change
colum count to 2 then change the column widths to 0:2 this will mean that you
select the item from the list and it will remain shown.

Please let me know how you get on

Falty
 
Back
Top