I am new to MS Access 2007, but I've got a deal of experience with the other office products, PHP, mySQL and many other technologies.

I am trying to create a macro that will open one of my tables and select a record for me using

OpenTable
SearchForRecord

However, I can get either command to work fine by itself, but when I put both together in one macro, the SearchForRecord ceases to function properly!

What can I do to fix this??

I wonder if the SearchForRecord is just for forms? Are you trying to search through the actual table? If so, what for? You might be better off doing this stuff in a form anyway....