May 1 2007, 01:06 PM
I have a table with two columns that use lookup wizards, and I have typed in my own selection options for the combo box.
Now I have created a form to populate the table. How do I use my combo box selections from the table in the form?
Right now it reads all preexisting information in the entire column, not the selection options created by the lookup wizard.
May 1 2007, 01:16 PM
You should not do this. I have attached the rant.
In the meantime, if the table had data in the column already, then changing the field to a combo box is not going to do anything to change the existing data. You'll have to do that yourself.
May 1 2007, 01:50 PM
hmm... thanks, but this is that way I was told to do it. Someone here at the offices has a working model. Have a good day.
May 1 2007, 02:13 PM
Told by whom? The ONLY value I see in using Lookup fields on the table level is that you can drag the field from the Field List onto a form (or use the Form Wizard to create your forms) and the control will pick up the settings from the table.
However, if you make any changes to the table or the form, they will not be reflected in the other. This is especially irksome if you use a value list. You would have to make the changes WHEREVER you use that field.
Since users should never have direct interaction with tables, there is really no reason to use lookups on the table level.
Fee free to show this thread and the article Frank attached to whoever has told you to use them.
May 2 2007, 07:36 AM
Told by my boss. I am a gofer (gofor) here at the office with a little access knowledge (very beggenner), but enough to accomplish so far what they have needed. I think my problem is I did not explain right.
Thanks for the advice.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here