In my opinion that is a bad thing to do. You should not use lookups at table level unless you are very, very experienced and know of all of the pitfalls of doing so.you should still be able to do it in a table if you prefer to... go to table design view... lookup tab... display control change to list box/combo box
In my opinion that is a bad thing to do. You should not use lookups at table level unless you are very, very experienced and know of all of the pitfalls of doing so.
Yes, but without sharing the possible pitfalls to that suggestion is why I chimed in and stated thusly.just saying that it is possible
See if this helps:Thank you to all who have posted. Today is my first day at the forum.
I did find another item posted 11/14/2003 from Mile-O which stated:
You need the combobox to be on a form.
Once you have the combobox on a form ou can reference it in the criteria: i.e. [Forms]![MyForm]![MyCombo]
Okay, SQL is not my first language.
Can anyone help step me through this process?
If I am in the query - which is based on a table.
The data entry for the table is a form with a combo box.
What next?
Thanks,
Valerie
So can you outline the exact steps you have tried to do?Thanks for the link and awesome information.
I have tried the solution.
It did not work.
So did you actually build a form with a combo box on it from which you would be selecting the parameter value for the query?I discovered the "loaded form" is one that you open in the design view before the expression builder.
How about you upload your database here with fake data so then we can put it in place and you can see how it is done?Still no drop down menu in the parameter box.
You can use combo boxes in FORMS for data entry. NOBODY should be doing data entry directly into tables.Thanks for the additional information. I appreciate your expertise.
We use the lookup combo boxes to enhance accurate data entry.
This improves data integrity by refining criteria for queries and reports.
We have kept the process of queries pretty simple, but obviously by the information you provided the more complex, the more problems we may encounter due to masking relational methodology.
I appreciate the advice and am learning alot on this forum.
Thanks,
VA