moose
10-10-2002, 01:11 AM
i have a form that a user can fill in and once they have done their bit i want them to be able to click on a button and email it to a selected person. as far as i am aware you cant email a form but when i try to create a report it looks nothing like the form (i want them to be identical). can anyone tell me how to create a report that will look like the form please?
also can you tell me if i can use command buttons and other controls on a report please
Reports are not user interactive, there's no point putting combo boxes, command buttons etc. on them.
If you want your report to look like your form, save the form as a report
moose
10-10-2002, 06:02 AM
could you tell me please how to save a form as a report
Yes for some strange reason Microsoft never added one of its most useful features to the toolbar by default, you have to drag the icon from the customise toolbar option
moose
10-10-2002, 07:31 AM
Great, I found that, the only problem now is, the report has a page for each for that has been filled in so when i try to print 1 form (report) it prints all forms, and there are 84 at present
so how would i do it so that it only prints the form being viewed
moose
10-10-2002, 08:08 AM
i think i have half solved it, if i use the print from the file menu, i can select page 1 to 1 for print but i dont think i can rely on the users to do that and if they dont i am going to get alot of wasted paper.
what i need to do is automate it somehow
Either use a query with the criteria set to the current record, or the Open Report method with the Where condition, there have been numerous posts here if you want some examples