Report for an individual record

[smeagain]

Hi, Following my previous post, I would like to ask can I create a report for an individual record in a table rather than for the whole table iself.

 

[pbaldy]

I often use this technique:

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

 

[smeagain]

Hi thanks, that sounds exactly like what I want but I am no good with programing and would not know where to add it and what to alter.

 

[the_net_2.0]

Hi thanks, that sounds exactly like what I want but I am no good with programing and would not know where to add it and what to alter.

please look at the help article on "docmd.openform". look that up and check out the arguments. the "openreport" method of the 'docmd' command has almost the same syntax, if not exactly the same.

Remember if you do look at the article, that optional arguments for the method begin when you see the first bracket ([) in the complete syntax at the top of the article. Everything between the two brackets ([]) are optional arguments.

 

[pbaldy]

It would look like

DoCmd.OpenReport "ReportName", acViewPreview, , "FieldName = " & Me.ControlName

adjusting as required by the data type. The place would be the event you want to call the report from, often the click event of a button.

 

[SpentGeezer]

Who is John Galt?

 

[the_net_2.0]

Who is John Galt?

LOL. I would've asked a long time ago but I didn't want to look like a moron.

 

[pbaldy]

LOL. I would've asked a long time ago but I didn't want to look like a moron.

It's a phrase from one of my favorite books:

http://en.wikipedia.org/wiki/John_Galt

 

[SpentGeezer]

@ netty pffffffffffft

 

[SpentGeezer]

Interesting.....Does he find the real John Galt?

 

[the_net_2.0]

@ netty pffffffffffft

I've seen something like 4 posts from you thus far Geezer, and from what I've seen, I would expect exactly this from you. I'm out of this thread now.

Good luck helping the OP.