Linking from a report to a form for same record

[AaronBergquist]

How can you make a report that allows you to have a link or button for each
record that displays which you can click and it will open a form for that
specific record?

This maybe easy, but I am still new to access. I appreciate any support that
can be provided.

 

[Steve]

A report is used to print out selected data in one or more tables in your
database in a selected format. A report can be previewed before printing. A
report is not interactive so it is not possible to do what you describe.
However, a list of data can be displayed in a form. A list consists of
multiple records and each record can be multiple fields. Each field in a
recprd has a click event and you can put code in the click event that opens
another form for that specific record.

Steve
(e-mail address removed)

 

[Gina Whipp]

Aaron,

I think what you want is...

If your field is text...

DoCmd.OpenReport "YourReport", acViewPreview, , "[YourIDField]='" &
Me![YourIDFieldOnYourForm] & "'"


if your field is Numeric...

DoCmd.OpenReport "YourReport", acViewPreview, , "[YourIDField]=" &
Me![YourIDFieldOnYourForm]

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

How can you make a report that allows you to have a link or button for each
record that displays which you can click and it will open a form for that
specific record?

This maybe easy, but I am still new to access. I appreciate any support that
can be provided.