I
Israel
I have been searching on the web for awhile for the answer to my question. I
would like to find out how to allow a user to choose a option that will limit
the Lookup List. I believe that the answer has to do with filters and using
a table as a filter. I have looked at the northwind template and in the
sales report dialog form there is an area that allows the user to choose a
option; by selecting that option the form then changes the lookup list
information to match the option. I am needing a form that a user can choose
the width, height, or length of a object and then the form will only let the
user select from a list of options that has the correct size. I am using
Access 2007 and would be very thankful for any guidance.
would like to find out how to allow a user to choose a option that will limit
the Lookup List. I believe that the answer has to do with filters and using
a table as a filter. I have looked at the northwind template and in the
sales report dialog form there is an area that allows the user to choose a
option; by selecting that option the form then changes the lookup list
information to match the option. I am needing a form that a user can choose
the width, height, or length of a object and then the form will only let the
user select from a list of options that has the correct size. I am using
Access 2007 and would be very thankful for any guidance.