Link from report to record form

[John2360]

Hello everyone, I am a new access user and have started to create a database for my work. The purpose of my database is to track products coming in for repair. I have designed a form to inputting data and have created a query to look for outstanding repairs which brings up a report, what I would like to do is have a link from my report to the record of the current repair, for example I have my report up with my repairs on and when I click on one of the repairs numbers it takes me to my data input form for that repair. Is this possible? I am not the best with code thanks, John

[June7]

Instead of report, why not open a form of the outstanding repairs? Pick one and edit right there. I've never used a report to open a form for a specific record. Not sure can even be done. Reports don't have a record selector. Reports are intended for output, not to be interactive.

[John2360]

Thanks for the reply June7, I'm not too sure how I would do that. Do I need to create another form?

[June7]

Don't know. What is the form you already have? Might need a form/subform arrangement. Or just build filter capability into the existing form. Review http://datapigtechnologies.com/flash...tomfilter.html

If you want to provide your db for analysis, follow instructions at bottom of my post.

[richimo]

Hello everyone, I am a new access user and have started to create a database for my work. The purpose of my database is to track products coming in for repair. I have designed a form to inputting data and have created a query to look for outstanding repairs which brings up a report, what I would like to do is have a link from my report to the record of the current repair, for example I have my report up with my repairs on and when I click on one of the repairs numbers it takes me to my data input form for that repair. Is this possible? I am not the best with code thanks, John

I've asked this same question in a few different places - Most common answer = 'It can't be done, reports aren't interactive'. Someone turned me on to an option though, using a little VBA. Make a field 'Enabled' in the properties section, and link it to the form. My current problem is in the VBA I think. When I click the 'record number' I've made active, it brings up the form, but it's not on the right record number, just defaults to the first record. I'm making progress, but I'm not there yet. But I think I've gone far enough to be able to say 'it might be possible, don't give up yet'. I'll pass along any new info I find!

http://www.reddit.com/r/MSAccess/com...pen_up_a_form/

[pbaldy]

Reports in Report view are interactive; Preview and Print are not. I'd use this to bring up the record:

BaldyWeb wherecondition

[June7]

As Paul said, in Report view reports can be somewhat interactive. Buttons will work. I did a little test. Button in report header with code to Debug.Print ID of record. It always output ID of first record no matter where I placed the cursor.

[pbaldy]

The button or textbox would need to be in the detail section to work correctly.

[June7]

AhHah, that does sound familiar. Think I have tested that before but just did again to verify. The button will display with each record and use the ID of the record the instance of button is associated with.