Opening a record

[Reen]

How do I open just one specific record in access? I have table open (is it
the table table?) and can I print this record in form format?

 

[Jerry Whittle]

Use the Form Wizard to create a form based on that table.

However forms don't print out all that well. Reports do a better job. After
creating the form above, do a Save As and save that form as a Report. Then
you'll have both a form to enter, edit, and view data plus a report to print
out as necessary.

 

[Reen]

Thanks that does help, now how about going back and opening one record out of
a whole data base, how do I do that? Thanks

 

[Jerry Whittle]

I knew that you'd ask that.

If you are only interested in one record at a time, you could base the form
and report on a query. Put a parameter like [Enter the Control Number] in the
criteria of the appropriate field. That way when you open the form or report,
it will ask you that question and, hopefully, return the correct record.

If you need to open all the records, but sometimes find a specific record,
you could click on the field and use the Find icon or dialog box in Edit,
Find. You could also use the Filter by Form or Filter by Selection options.

Reports are a little more difficult as there can be more than one record per
page. Plus reports print out by pages. There are some example of how to find
a record with a form then press a control button which will create a report
for just that record. Also if you make the form rather plain, such a few
colors or graphics, then a form can print out somewhat acceptably.