Macros: Where?

[tthao]

I can't fingered out how to PRINT a single report page from the macro button on the form. I could set it to print the whole data set, but not the particular page I'm on the form.

I.e. I'm on record 330 under form and wanted to print the same form record on report.

File:
Table- CCC Gate Table
Form- CCC Gate Form
Report-CCC Gate Report

The main question is how do you write the expression statement on 'where condition' to open up report and record 330.

Here what I did so far: Created macro:
1) OpenRepor: 'Report Name': CCC Gate Report; 'view': Print Preview;'Filter Name': None; 'where condition':?;'window mode': normal.
2) PrintOut:'Page Range': All; all others: default
3) Close: Close Report; CCC Gate Report; yes

Again, my question main question is "Where Condition" expression.

Help!

-TT

 

[pbaldy]

In code it would look like:

http://www.baldyweb.com/wherecondition.htm

 

[hiền muội]

Example: CCC Gate Report has Recordl Source:tblCCC_Gate (ID,Col1,col2,...)

If you want to print ALL Records--> Where Condition : none
If you want to print some Records which ID="x"--> Where Condition:[ID]="x"