The last laugh

[potts]

Could someone please help - I'm having a no-brainer!!

I have a continuous form containing basic information regarding articles. The fields are:

ArticleID - unique ID
Title - article title
Yr - year published
Print - a check box

What I want to do is to have a command button that when clicked opens a report (called Reference) containing only those reports that have the check box ("Print") ticked.

Could someone show me how to write the VBA for this procedure please - it's the last thing I have to do.

Like I say - I'm having a no-brainer.

Thanks a million

 

[WayneRyan]

Hi potts,

Make a new query that points to your table and includes all
the fields, with the criteria for Print = -1.

Design your reference report and point it to your query.

On your command button put a line of code like:

DoCmd.OpenReport "Reference", acViewPreview

I don't have access with me so I'm not sure about the syntax,
but that's the general idea.

hth,
Wayne