2007 Open Form Command Button does not work at all!

[rp3886 via AccessMonster.com]

I am trying to do something very simple that was no problem in Access 2003. I
am inserting a command button, via wizard, to open a new form to a specific
record. It opens the form, but it opens it to an arbitrary record (the same
record every time) and not the one I am on. I have my relationships set up
and there are corresponding records in the two forms. The embedded macro that
is created by the wizard is as follows:

frmFinancial, Form, , "[strIDISNumber]=" & "'" & [strIDISNumber] & "'", ,
Normal

I do not see what is wrong. Right now, I cannot link any of my forms properly.
I had to recreate the forms in 2007, because there were some transfer issues
from 2003. So these forms are strictly 2007. I have even tried to recreate it
in a dummy database that was created in 2007 as well, and it still does not
work. Please help!!! Thank you !

Regina

 

[Allen Browne]

Make sure your A2007 database is in a trusted location. To trust your
folder, click:
• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new location (button)

If that doesn't work there may be a reference problem:
http://allenbrowne.com/ser-38.html

Or it may need a compact, decompile, compact sequence. Follow the recovery
steps here:
http://allenbrowne.com/recover.html

 

[rp3886 via AccessMonster.com]

Thanks! I will give this a try and let you know.

Make sure your A2007 database is in a trusted location. To trust your
folder, click:
• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new location (button)

If that doesn't work there may be a reference problem:
http://allenbrowne.com/ser-38.html

Or it may need a compact, decompile, compact sequence. Follow the recovery
steps here:
http://allenbrowne.com/recover.html

I am trying to do something very simple that was no problem in Access 2003.
I

[quoted text clipped - 19 lines]

not
work. Please help!!! Thank you !

 

[rp3886 via AccessMonster.com]

Hi Allen,
I have tried making the folder trusted and the recovery sequence and neither
worked. I am unsure about unlisting and re-registering the libraries, since
this is a work computer. I do not know what is wrong. I think I will go home
and try this there. If it works, then I may try doing the libraries. If all
else fails, then I may get them to reload Office 2007 on my work computer.
Thanks! I will let you know if this works.

BTY - the recovery sequesnce left all of my buttons useless.

Thanks! I will give this a try and let you know.

Make sure your A2007 database is in a trusted location. To trust your
folder, click:

[quoted text clipped - 17 lines]