How to save data in lookup field from a combobox

  • Thread starter Thread starter Mohammad Sibtain Arain
  • Start date Start date
M

Mohammad Sibtain Arain

I want to save data in a lookup field from a combobox, lookup field and combo
data have the same items in the list , furthermore combo box is enabled to
select multiple items from the list
i m not able to do it programatically can anybody explain it how i can do it
i am stuck and getting behind my schdule just cuz of this one issue.
 
I want to save data in a lookup field from a combobox, lookup field and combo
data have the same items in the list , furthermore combo box is enabled to
select multiple items from the list
i m not able to do it programatically can anybody explain it how i can do it
i am stuck and getting behind my schdule just cuz of this one issue.
Click to expand...

Simple solution:

Change the structure of your database so you don't need multivalue fields and
don't need lookup fields.

Instead, use a related Table to store the multiple values. That's what Access
does, under the hood where you can't see it, when you create a multivalue
field. Unfortunately Microsoft doesn't expose that hidden table to view, or
allow you to manipulate it.

As far as I know there is NO way to do what you ask, if you insist on using
these misdesigned and limited features. Fortunately it's been possible to
accomplish your desired end goal - storing the data in tables, and allowing
editing and updating - *without* any use of these features.
 
Back
Top