Parameter queries and parameter queries

[trawets]

Hi

Don't know if Ive got the title right but I least I know what I mean
(I think)

I have been doing some parameter queries with combo boxes to choose
values,run qureies and the open reports, what I would like to do now
is have a form that can run a query from a drop down list

something like a contacts db

I would like the first box to show all the companies I have in a
table, the when I select one I would like only the contacts for that
company to be visible in the next drop-down box so I can choose which
contact I want and then display their contact information. in a form
view where it could be edited if required

That doesn't sound too hard does it (well not if you say it quick)

Could someone please suggest a tutorial or some reading matter for
this type of action or any suggestions at all really
I have always received very good and sound advise here so many many
thanks in antcipation.
Regards
Stewar

 

[akphidelt]

Not sure if this helps... but the way I do it is like this...

1) Set up a table (maybe you already have) that has the contacts and the
companies.

2) Set up a query with the contacts and companies

3) In the query parameters box under the companies column... put in the
value of the combo box from the form... (i.e. Forms!frmContacts!cboCompanies)

4) Attach the contacts part of the query as the row source of the contacts
combo box. Make sure you set the first combo box to requery the query after
each update.

Let me know if this helps or if you have any questions.

 

[Douglas J. Steele]

See whether
http://office.microsoft.com/en-ca/access/HA011730581033.aspx?pid=CH063650361033
is what you're looking for.