Combo and form

  • Thread starter Thread starter Georgi
  • Start date Start date
G

Georgi

My form gives criteria to run a report based on parameter
query, I've added a combo box, how can I get my report
to recognise the name chosen from the combo and display
data only for that name.

Something akin to North Wind categories report (pick from
list to dispay report based on that)

Many thanks in advance.
Georgi
 
Assuming you run the report off a control on the form -

In the query which the report runs off you need to add the
following to the Name Field

[Forms]![name of your form]![name of the name field]

eg

[Forms]![Sales]![Price]

Hope this helps.
Ian
 
Hi when i go to save, it comes up with an invalid ! or .
(dot) or invalid parentheses
-----Original Message-----
Assuming you run the report off a control on the form -

In the query which the report runs off you need to add the
following to the Name Field

[Forms]![name of your form]![name of the name field]

eg

[Forms]![Sales]![Price]

Hope this helps.
Ian
-----Original Message-----
My form gives criteria to run a report based on parameter
query, I've added a combo box, how can I get my report
to recognise the name chosen from the combo and display
data only for that name.

Something akin to North Wind categories report (pick from
list to dispay report based on that)

Many thanks in advance.
Georgi
.
Click to expand...
.
Click to expand...
 
Back
Top