Limiting a combo box list to only contacts from that company

[richo]

I have a database that has 1,600 companies in it. The problem l have is when l bring up a company in a form and then go to a subform in the form that has company notes in it. When l make a note l select a person from a drop down list. This is where to problem is, when l drop down the list it has every contact for every company in it, which is very large. How can l only have the contacts from that company appear?

 

[Lightning]

If the recordsource for your combo box is a table (static list), change it to a dynamic list by using a SQL statement with a WHERE clause on your combo box to restrict the data in the combo to only those contacts from the company required. This could be looked up from the Company field on your main form.

Check out the on-line help item "Customize a List Box, Combo Box or Drop Down List Box" for more information.

HTH
Lightning

 

[richo]

Sorry Lighting where is this on line help?

Thanks

 

[Lightning]

The help screens obtained by clicking on the Help Menu item in the Access menubar.

From the database window, click on:
HELP (the last item on the right-hand end
of the menubar)
CONTENTS AND INDEX (the second item in the drop-down
list)

This opens the Help dialog box. Select the "Index" tab and type in "Customize a List Box, Combo Box or Drop Down List Box"

Lightning