How to sort by selecting a field

[Kevin]

I have a report that prints out the information that i need. What i need to
work out how to do is select only certian files. In my form i have a tick box
which gives a "-1" result in the table. How do i instruct acces to only
select the fileds that have this "-1" value. I know that i need to use the
select and sort option, but i cant work out how to tell the report to only
select the files that i want

 

[Damian S]

Hi Kevin,

Try opening your report like this:

docmd.OpenReport "REPORTNAME", acViewPreview,,"FIELDNAME = True"

Hope this helps.

Damian.

 

[Kevin]

Thanks Damian, i am sort of heading in the right direction now. I am using
the Switch Board Manager to move around. Do i build the code in the "On
Enter" of the properties