Command button "Detail for specific entry"

[Daimios]

Hi everyone,



I'm new at Access and currently try to basically create a form that will display all my entries, but with a button next to each entry that will open a "detail" form for this specific one.

I have placed a button with the action "OpenForm" but it keeps opening the details for all entries on the same screen, I don't find the switch to make sure it displays only the details to the entry to which it is related.

Could anyone help ? That'd be highly appreciated

Thanks !

[pbaldy]

This type of thing?

http://www.baldyweb.com/wherecondition.htm

[Daimios]

Yes that type of thing, but it does not seem to work for me, but I might do something wrong.

I added a button and pasted the following code in it : DoCmd.OpenReport "E_Detail", , , "Pseudo = ' " & Me.Pseudo & " ' "

E_Detail being the detailed report for the entry selected
Pseudo being the entry on which I want the filter applied in the detailed report AND the name of the entry in the general report.

The result is quite surprising : it opens Microsoft OneNote and pastes the E_Detail filtered, but on the first entry only. That is, imagine that I have 3 entries in the general report : Bob, Rick & Will. Clicking on any of the three command button will open OneNote with E_Detail for Bob (even if I expected Rick or Will).

[Daimios]

Actually, what I also tried is creating a macro OpenReport with condition [Table General]!Pseudo = [Pseudo]. When I do this, the filter works fine but .. a window pops up when I click the command button to ask me for the value of [Pseudo]

[pbaldy]

For starters, try without the spaces:

DoCmd.OpenReport "E_Detail", , , "Pseudo = '" & Me.Pseudo & "'"

in the macro, I'm pretty sure you need the full form reference. If you're still stuck after trying the above, can you post the db here?

[Daimios]

I did try with more precise references (not only "Pseudo") and without spaces but that did not solve the problem.

DB can be downloaded here : https://docs.google.com/file/d/0B-0K...it?usp=sharing

Thank you !

[pbaldy]

Seems to want a password. If you do a compact/repair then zip it, you should be able to attach it here.

[Daimios]

It should work now

[pbaldy]

This seems to work:

DoCmd.OpenReport "E_Detail", acViewPreview, , "Pseudo = '" & Me.Pseudo & "'"

[Daimios]

Actually I just figured that it works even better with acViewReport, to keep it in the same format (not the print preview one)

Thanks a lot for the quick help !

[pbaldy]

Happy to help!