regarding combo and list boxes

[cnuhima]

Hi,

In my application i have a combo and listboxes for which i have values from the queries..without using the wizard..

But when i select the item in the list box ,its not saving in the table.

what might be the solution for it...

Help me out..

With Regards,
Himabindu.B

 

[boblarson]

The control needs to have its CONTROL SOURCE set to a field in the table (bound control). Is the rest of the form bound too? If so then it would be a matter of setting the control's control source to the appropriate field.

 

[cnuhima]

I have done it..In the control source option i have the field name of the table which it has to bound.

Control source has the list of field in the table ..so i selected the appropriate field from them..

help me out..

With Regards,
HimaBindu

 

[cnuhima]

Hi,

The values which i am not able to store is the Listboxs.I got the values stored in combo box..

Help me out..

 

[boblarson]

Are you trying to store more than one value from the listbox? A listbox can be a single select listbox and store the value in the field. If it is Multi-select then you can't do that normally. You would either

1. Need code to store the values (and not advised), but instead you create another table to store the multiple values for each record and use a subform for them.

2. If using Access 2007 then you would need to set up a Multi-value field.

 

[cnuhima]

Thank you very Much.

 

[cnuhima]

Hi guys,

Is there any other alternative..with out creating another table or subform..

Please help me out..

 

[boblarson]

Is there any other alternative..with out creating another table or subform..

Not unless you are using Access 2007. If not, then it is a coding headache (and I don't want to go there). Multiple values should be stored as records and not in a single field. That is the relational database way.

 

[cnuhima]

Thank you Verymuch.Can you explain me how to do that using 2 tables...