This is probably dumb, but I am new to Access and learning fast (but not fast enough)
I am trying to set up a 3 part form: the main form selects a company from a list, the first sub form selects a contact from a list from the selected company and the third form selects an action from teh selected contact.
I have created the first subform using a wizard and the contacts are limited to those in the related comany but when I add a List or Combo box all of the records in the contacts file are on view (I use the option *Find a record on my form based on the value I selected in my list box*)
How can I limit this so I only get the contacts that belong to the related company?
Thanks
I am trying to set up a 3 part form: the main form selects a company from a list, the first sub form selects a contact from a list from the selected company and the third form selects an action from teh selected contact.
I have created the first subform using a wizard and the contacts are limited to those in the related comany but when I add a List or Combo box all of the records in the contacts file are on view (I use the option *Find a record on my form based on the value I selected in my list box*)
How can I limit this so I only get the contacts that belong to the related company?
Thanks