problems with printing forms

[reservedbcreater]

ok i was on a form i wanted to print
and it stated to print all 900(each record represents a survey) records
for that form........what i need is just the 1 record i was at

and i need to print the form and not a report, because the forms are a
survey, and they want to see a copy of a filled out survey. so i got to
record #3 in the form for example and click print
- i need the form filled out with #3's record

and filling the print page because when i first tried printing it didnt
show the entire form on the print page

please help

 

[Rick B]

As previously posted many times in this group. Build a report (reports are
for printing, not forms). You can make the report look just like your form
if you want, but reports let you format things for paper. You don't want a
drop-down combo box on a report (for example) but you do on a form.

Build a button on your form and call it "print current record" or something
similar. Tie code to it like...

Private Sub Print_Button_Click()

If (IsNull([UserID])) Then

' Verify the key field (UserID) has a selection

Exit Sub

End If

DoCmd.OpenReport "SomeReportName", acViewNormal, "","[UserID] =
Forms![frmSomeFormName]![UserID]"

End Sub



Click this button on each record you want to print.







If you want to add a bunch of records, then print them, a report is
DEFINITELY the way to go. You just need to tell it in the underlying query
(or via a prompt) to only print the records added today, or only print
records added between a certain time, or using a certain range of reference
numbers, or some other criteria. You will have to figure out how Access
would know which ones to print though. You can't just expect it to know
that you don't want all of them.







Rick B

 

[reservedbcreater]

ok thanks very much this help but....


see there are 17 tables
and all 17 tables are one long survey with many sections
so each table has ID# field.....
so each record over all 17 forms/tales has its own id#.....so i'd need 17
forms to print out filled in with all the info of id#3

so if i clicked print it would say which ID#

if i put 3 i'd want it to print out each for fulling filled in for ID#3

can u tell me how id do this in a report?

 

[Rick B]

Build your report based on a query that contains all 17 tables. I would
guess that each table would have the id number in it.

How did you build the form? Build the report the same way.

Rick B

 

[Rob Oldfield]

What you actually have here is *one* of the problems that have been caused
by not having a normalised table structure. I'm afraid that it's a good
example of why getting the structure right from the start is worth doing.

 

[reservedbcreater]

thanks