I want to use different lookup columns for dropdown list for the same field in a table, the lookup column I use would depend on which form was being used. For example if I have a table using a lookup column with about 150 entries in the lookup column and I want to restrict which of these entries that are displayed and used by a user depending on which form is being used.
look up columns
- Thread starter dgoold
- Start date
Ally
Registered User.
- Local time
- Today, 18:32
- Joined
- Sep 18, 2001
- Messages
- 617
Do you actually mean columns or records? Columns, doesn't really appear to make a lot of sense, because the same ID will be recorded anyway.
If you are opening different forms, then you can set different criteria within a query that feeds the combo box.
If you are opening different forms, then you can set different criteria within a query that feeds the combo box.
I got the term Column from using lookup wizard in table design view in the data type section. Thanks for the idea on creating it within a query I've tried this before and had problems but with your advise I went and tried again and was successfull. Once again thanks for helping a newbie.
Similar threads
