Access 2003 Form Breaking When Opened in Access 2007

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have an Access 2003 database that is sometimes opened on a machine with
Access 2007. For the most part everything works in 2007.

However, if I create a botton on a form that is supposed to open a separate
form to a specific record, it fails. IOW the new form will open but on a
blank record, not open to the specified record.

I just created a simple test form and let Access build all of the code to
open the new form to the select record. This is what I got:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Definition_POP"

stLinkCriteria = "[DefinitionID]=" & Me![Combo0]
DoCmd.OpenForm stDocName, , , stLinkCriteria

But when I click the button, it opens to a blank record, not to the
specified record (Record 1 of 1 with the filter icon on).

I tried different IDs and it is always the same, open to blank record.

When I first open my db in Access 2007 I check the "enable content" radio
button but is there something else I need to do to enable this standard
functionality in Access 2007?
 
My error.

This was not a 2003/2007 compatibility issue.

Instead the "Data Entry" and "Allow Additions" properties of the popup form
had been set to "yes." This prevents the form from displaying the selected
record.

Never mind.
 
Back
Top