There is a SERIOUS bug in Access 2007. I discovered this after a couple of you emailed me and posted in the Forums that you're trying to follow one of my lessons (Access 202, Lesson 1) where you use the Command Button Wizard to "open a form and find specific data to display." Specifically, where you click on a button on the CustomerF form to open the ContactF form and show that customer's contacts.
Well... it doesn't work in Access 2007. Yes, it's a BUG.
The good news... it's FIXED in Office Service Pack 2.
So if you haven't downloaded SP2 yet, now is the time to do so. After playing with this for an hour and researching it online, I found many mentions of other nasty bugs in the Office 2007. I'll be the first to admit that I don't usually apply service packs myself until I have a reason to do so (bug, problem, etc.) but this is definitely a reason to download and install SP2.
I had the original release of Access 2007 on my machine. I tried creating a command button using the wizard. It didn't work. It opened the form and showed ALL records even though I picked "specific records" in the wizard.
The command button wizard in Access 2007 creates something new called an "embedded macro." Instead of generating VBA code like previous wizards did, this new wizard makes a macro that's embedded (stored) in the form itself. I don't particularly care for it, but I can live with it.
See, I never would have found this bug otherwise because I always write VBA code by hand. I don't usually rely on the macros. It's one simple line of code:
DoCmd.OpenForm "ContactF",,,"CustomerID=" & CustomerID
That's it. That's all you need to open a form and show a specific record or records. You can do the same thing with a report too (just change OpenForm to OpenReport).
So, for those of you having trouble with this, download Office Service Pack 2 from Microsoft. It's free, but its 200 MB, so unless you have a FAST connection, be prepared to go get lunch while it downloads.