Expand and reduce information in form? (I don't know how to ask)

[floyd]

I have a query which, when run, populates with file names various file names which fit certain criteria.
I am trying to figure out how to create a BUTTON which allows the user to open more information about that specific file in a pop-up box.

In other words... I initially get the file name in the first query and I click on (Get more information) button
it opens a pop up which has additional information about that file as well as the link to the file.



This seems like it should be SOOOO simple, but I can't figure it out!!!

[pbaldy]

Is this what you're after?

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

[floyd]

Oh my gosh... I haven't tried it yet but that looks EXACTLY like what I was trying to do!!!
Amazing that 2 hours of google searches and I couldn't find this!!!!

I will let you know how (when) it works!!!

[floyd]

NUTS... I am getting an error.
Here is my code:

Private Sub Command82_Click()
DoCmd.OpenForm "4_qryFileExpanded", , , "PKMainFiles ='" & Me.PKMainFiles & "'"
End Sub

The expression OnClick you entered on the event property setting produced the following error: A problem occured while Microsoft Access was communicating with the OLE server or activeX control

[pbaldy]

Can you post the db here?

[floyd]

Here is the database in question.

The forms I am trying to work on are the following:

1. 4_qryFile (This is the minimized search result)
2. 4_qryFileExpanded (This is the form which I would like to open to show all the file info)

Please let me know what questions I can answer.
(I'm certain there are ALL KINDS of ISSUES I don't know about)

I would LOVE to hear any suggestions / comments you have.minimal.zip

[floyd]

I assume this is either...

1. too screwed up to fix
or...
2. Sooo simple that no one wants to help

[pbaldy]

A combination of both I think. The technique is really simple, and I use it all the time. The error you're getting is unusual, and I suspect means the form has gotten corrupted or something. I was waiting to have time to research, but see if this helps:

http://support.microsoft.com/kb/907337

[floyd]

It's working!
I had to go back and look at my linkages... and now that I did... it's working FLAWLESSLY!!!!
THANK YOU for all the help.
You have NO IDEA how much this has meant!!!!

Joe

[pbaldy]

Happy to help!