sql coding on access 2007 reports

[Ali DEĞİRMEN]

hi,
i want to learn writing sql codes on reports (ex. control source) i'm taking
the datas form an order form and i want to select another column using the id
value coming form the form.after all i want to write it to report(textbox).

i'm think it will be like this but its not work.
select from contact.telephones where id = orderform.companyname

 

[Klatuu]

You do not use SQL to get data from forms. SQL is used only for tables and
queries.
If you want to get the value from a form control in a text box on your
report, it is:
=Forms!orderform!companyname

 

[Ali DEĞİRMEN]

i see but i want to get (for examples the call numbers on the same row )
using company name or company id (variable of the form)