cannot delete form records...

[ACastelo]

I have a form that basically just pulls all of the data from one table(
select * from tablea. In the Delete button I have the following code:

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord

The message that I get is: "The command or Action 'DeleteRecord' isn't
available now"

Now, the intersting thing is that if I open the application for
development, and I run the form from there, I am able to scroll through
the records and delete them. When I run the entire application, I can
see the form,scroll through the data, etc but when i try to delete a
valid record(not at end, etc) it gives me the above message.

I checked for allowdeletions, updateble query, modal =off, popup=off
etc, all of those settings are correct.

Any other ideas?

thanks,
Acie