Question Contact Details Database - Access 2003

[confused_chap]

Hi,
I am supposed to be building a database to manage my boss's contacts, and I'm hitting a wall with one aspect. I have it all figured out except I can't find a way to browse all the contacts at one time. For instance I would like it to be set up so that when he opens the form there is a drop down list of the company names which he can choose from and then all the contacts at that company appear when a name is clicked.

I don't want to start building it until I have the all the aspects worked out, so any help would be much appreciated!!

 

[neileg]

You need a combo box to choose the name and then build a form or subform based on a select query that uses the combo box value as a criterion.

 

[alktrigger]

You need a combo box to choose the name and then build a form or subform based on a select query that uses the combo box value as a criterion.

is correct.

say you want to show the contacts on frmContacts.
add a combobox (cmbCompany) that reads data from what should be your tblCompanies (note: if you didn't normalize in this manner, create a query that groups by company name and name it something qryCompanies)
then create a query that generates the data you want your boss to see (include company) and for criteria use "[Forms]![frmContacts]![cmbCompany]" (under company)
Go back to frmContacts!cmbCompany and change the "on change" add a macro that uses the "requery" command(or vba docmd.requery), and dont forget to create the subform from the query on frmContacts

hope this helps

 

[confused_chap]

Thanks for the tips guys, hopefully that should do the trick!