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

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.

"trawets" wrote:

> 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
> 

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

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"trawets" <stewartrsmith@gmail.com> wrote in message 
news:2514a59e-878c-4bee-a9d4-b61e3b6d3fea@e10g2000prf.googlegroups.com...
> 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