Hello, and thanks for the help I've gotten here so far. I have a very
stable database created for fairly complex uses, mostly it's our crazy
clients and their manifold relationships to our company as writers,
songwriters, musicians, etc. There a hundreds of issues with some of
these contacts. Anyway, I created a database of sorts to help me keep
track of what was going on with any given writer at any given time.

And it works great, I made it for my own use, but now my boss has
gotten into the habit of demanding all the current info on a given
client, in a neatly printed form. Adding a Print Current Form command
button isn't that useful, there are three memo fields with a lot of
text, and a bunch of check boxes that show me are they in a current
contest, are they a past contributor, stuff like that I need to know.

What I'd like to do is have a command button I can click, that will
let me print out the most current info from the memo text fields, and
other info I can glean from the check boxes.

So it has to be the current record I have up on the form, and I want
to be able to format that print-out. Is this a record operation? A
form operation? A query?

As you can tell I am fairly new at this of course, I don't know
anything about the deeper level programming stuff other than some cut
and paste tricks. It just seems to me there should be a simple way of
printing out the current record from my main form with just the
information I want?
'
Once again thanks from someone who isn't very smart.

steve

First create a query that will display the same information being displayed
by your form.

Second create a report to display the information from your new query.

Third create a filter in your query in the Criteria row in whichever column
represents the primary key of your data. Probably something like
ContactID...or however you uniquely identify a contact. This filter would be
something like:

forms!frmContacts!txtContactID

Where frmContacts is the name of your form and txtContactID is the name of
the textbox on your form where the unique field is displayed.

Create a command button on your form with this line of code in the click
event of the button:

docmd.openreport "rptContactInfo"

where the name of your report (in this example) is rptContactInfo.

When you click the button, the report will run and the query bound to the
report will read the ContactID from the textbox on your open form and will
filter the query result set to display one Contact record that is currently
being displayed.

Good luck!
Mike



"Ibizar" <engsteve11 (AT) notmail (DOT) com> wrote

thanks!


On Fri, 16 Apr 2004 02:20:36 GMT, "bub" <bub (AT) hotmail (DOT) com> wrote: