Lookup Tables 3

[ecannizzo]

My company lookup table is not working well at all, which is causing several problems with some of my reports. When I use a combo box to lookup a company, the company is added again to the company table. I don't want it to be added to the table again, I just want it as a lookup table.
Any possibility that I could get some guidance on how to fix this problem?

Thanks for your help!
Erica

 

[BitTwiddler]

It sounds like you have the comboBox bound to a field in the same table that is the rowsource. When a comboBox control is bound to a field and you click one of the items in the list it will update that field in the current row of the form. If you just want to lookup a name but not have it update a field in a row, don't bind the comboBox to any field. When you click an item in the list it will put the value from the bound column in that field but that's it. As soon as the form is closed that value is gone too.

 

[ecannizzo]

I just need it to go to a table to get the list of values. How do I not bind the combobox, but have it look at the table and specific field?

Thanks for your help!
Erica

 

[BitTwiddler]

Select the comboBox on the form, open the properties dialog (View, Properties), click the Data tab, delete the field name value from Control Source property (first property on the Data tab). At that point it is no longer bound to any field yet it will still do the lookup and put the value in the field.

 

[ghubbell]

Helloooo Erica:
Here's the ticket just for you:

Thread702-33047 !
Gord
ghubbell@total.net

 

[ecannizzo]

I used the table analyzer to separate my data. It created a company look up table. (each company can have several people from my participant list-but each participant will have only one company.) I had a text box in a form which I changed to a combo box to look up the company values in the lookup table. When I use the combo box, the data is duplicated in the look up table. If I delete the control source for the combo box, I can't view the data in the form. This doesn't seem to be the most efficient way to do this. What are my options?

 

[RickSpr]

Your combo box's Control Source should not be set to the lookup table; it should be set to the participant table or company table or whatever table you want the combo box to update.

The combo box's Row Source should be (and, I expect, is) set to the lookup table.

In general, the Row Source property determines where the data in the list box comes from, while the Control Source determines where it is stored. Rick Sprague