Access 2003 Form Breaking When Opened in Access 2007

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?
 
D

Dave

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code error when opening a form 2
fomr opens to wrong record 5
cannot filter continuous form data 2
Form not populating 4
Data Entry = No 6
can't find form 4
Inserting data in forms 1
Sub Form Updating 3

Top