amatuer need help with Ms-Access!!

[squid-boo]

Hi... thanx for taking your time into these.

I'm only an amatuer programmer.. so I'm really having headaches dealing with this.

I've created a database with access, made a form for data input, and a report.

the thing is, after I've keyed in particulars in the form, I want to save it and print (the current entry) it out. simple as that.. having said that... here's my problem.

everytime I print.. the WHOLE database report will be printed out. example.. if I've got 1 entry.. fine, if I've got 2 entries, it'll print 2 reports. and imagine 20 entries, it'll print 20 reports!!! I'm only using the standard print command and I think that's why this is happening. can anyone help me out??

[diban]

Hi

Your report is currently picking up the data from the entire database.

One of the easiest way to get around this problem is to create a temp table, with fields that you want printed, empty this after every print and fill it on every save and use this tble in your report

The other way would be to write an SQL query in your report but since you are a novice, this will take you sometime to learn

Hope it helps

[squid-boo]

thanx for that info. it actually made sense to me

As easy as it sounds, how do I do it? possible to show me a sample code?