Choosing type of report or form

rtod2
rtod2 used Ask the Experts™
on
I need help deciding on which type of report or form to use.  I want to be able to add details and new records, as well as print, the same place.  I need some steps on which choice to make and why.  Assistance is greatly appreciated.

FORM OR REPORT

Needs 5 potential rows per record as follows ('if' data and/or attachments are available):

Row1 -> ID | Study | StudyType | Copyright
Row2 -> Notes
Row2 -> Attachment1 - picture of generic chart
Row3 -> Attachment2 - picture of upper or lower study depending on which one is attached
Row4 -> Reserved Words: | Input Parameters:
Row5 -> Code:

* Add new records
* Filter from within form or report, by those that have notes vs those that don't.
* Filter from within form or report, by type with more than one type available per record.
ChartInd1.13.accdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
MIS Liason
Most Valuable Expert 2012
Commented:
<I need help deciding on which type of report or form to use.  I want to be able to add details and new records,>
As soon as you need data entry, this will be a form.
The easiest way to make this form would be to use the form wizard and make a "Columnar" (Single Form) Form.
Then move the controls around manually until you have your desired layout.

As far as two of the other issue go:
* Add new records
Simply click the add new record button.

* Filter from within form or report, by those that have notes vs those that don't.
I have adreessed these issue in your previous question in post#36306780 here:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27237520.html
(Right click in the control and select the appropriate filter, or build your own filter based on the sample file I posted.


The third issue:
* Filter from within form or report, by type with more than one type available per record.
...is a bit more complicated and is a separate issue form the main thrust of this question.  As such, this would be better addressed in a separate, new question.

JeffCoachman

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial