Upgrade to 2007 breaks form link

[David Teich]

I finally upgraded to 2007 from 2003. I have a simple database to track
books, movies, etc.

Each type of media has an overview form listing all the database items.
Within an item, I could click the "detail" button and the info on the active
line would pop up in a new window. Now, with 2007, that code does nothing.

The code reads:
Private Sub Show_Detail_Click()
On Error GoTo Err_Show_Detail_Click

Dim stDocName As String

stDocName = "Book Detail"
stLinkCriteria = "[BookID]=" & Me![BookID]

DoCmd.OpenForm stDocName, , , stLinkCriteria


What changed in 2007 that broke that?

 

[Mike Painter]

Is the folder that the database in trusted?
A lot of things don't work in 2007 in untrusted folders.

 

[David Teich]

"Trusted"?? Is that a Vista thing?

Sorry, I forgot to mention I'm on XP SP3. I've dealt with folder properties
a lot and I don't remember seeing "trusted" as an option.

thanx,
David

Is the folder that the database in trusted?
A lot of things don't work in 2007 in untrusted folders.

I finally upgraded to 2007 from 2003. I have a simple database to
track books, movies, etc.

Each type of media has an overview form listing all the database
items. Within an item, I could click the "detail" button and the info
on the active line would pop up in a new window. Now, with 2007, that
code does nothing.

The code reads:
Private Sub Show_Detail_Click()
On Error GoTo Err_Show_Detail_Click

Dim stDocName As String

stDocName = "Book Detail"
stLinkCriteria = "[BookID]=" & Me![BookID]

DoCmd.OpenForm stDocName, , , stLinkCriteria


What changed in 2007 that broke that?

 

[Douglas J. Steele]

No, it's an Access 2007 thing (probably Office 2007)

Click on:
a.. Office Button (top left)
b.. Access Options (bottom of dialog)
c.. Trust Center (left)
d.. Trust Center Settings (button)
e.. Trusted Locations (left)
f.. Add new location (button)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

"Trusted"?? Is that a Vista thing?

Sorry, I forgot to mention I'm on XP SP3. I've dealt with folder
properties
a lot and I don't remember seeing "trusted" as an option.

thanx,
David

Is the folder that the database in trusted?
A lot of things don't work in 2007 in untrusted folders.

I finally upgraded to 2007 from 2003. I have a simple database to
track books, movies, etc.

Each type of media has an overview form listing all the database
items. Within an item, I could click the "detail" button and the info
on the active line would pop up in a new window. Now, with 2007, that
code does nothing.

The code reads:
Private Sub Show_Detail_Click()
On Error GoTo Err_Show_Detail_Click

Dim stDocName As String

stDocName = "Book Detail"
stLinkCriteria = "[BookID]=" & Me![BookID]

DoCmd.OpenForm stDocName, , , stLinkCriteria


What changed in 2007 that broke that?

 

[David Teich]

Thanx, that is new. Sadly, that didn't work. Forms still not popping up from
other forms though I've added the directory to Trusted.

David

No, it's an Access 2007 thing (probably Office 2007)

Click on:
a.. Office Button (top left)
b.. Access Options (bottom of dialog)
c.. Trust Center (left)
d.. Trust Center Settings (button)
e.. Trusted Locations (left)
f.. Add new location (button)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

"Trusted"?? Is that a Vista thing?

Sorry, I forgot to mention I'm on XP SP3. I've dealt with folder
properties
a lot and I don't remember seeing "trusted" as an option.

thanx,
David

Is the folder that the database in trusted?
A lot of things don't work in 2007 in untrusted folders.
David Teich wrote:
I finally upgraded to 2007 from 2003. I have a simple database to
track books, movies, etc.

Each type of media has an overview form listing all the database
items. Within an item, I could click the "detail" button and the info
on the active line would pop up in a new window. Now, with 2007, that
code does nothing.

The code reads:
Private Sub Show_Detail_Click()
On Error GoTo Err_Show_Detail_Click

Dim stDocName As String

stDocName = "Book Detail"
stLinkCriteria = "[BookID]=" & Me![BookID]

DoCmd.OpenForm stDocName, , , stLinkCriteria


What changed in 2007 that broke that?