Oops What have I done!

[Bob V]

Now when I click yhis control I am getting this error!
Run Time error '3112':
Records cannot be read;no permmisson on
-sq_ffrmBillStatement
Any Help Please

Private Sub cmdOwnerStatement_Click()
DoCmd.Close acForm, "frmBillStatement"
DoCmd.OpenForm "frmBillStatement", acNormal, , , , acDialog,
"OwnerStatement"


End Sub

 

[John W. Vinson]

Now when I click yhis control I am getting this error!
Run Time error '3112':
Records cannot be read;no permmisson on
-sq_ffrmBillStatement
Any Help Please

Private Sub cmdOwnerStatement_Click()
DoCmd.Close acForm, "frmBillStatement"
DoCmd.OpenForm "frmBillStatement", acNormal, , , , acDialog,
"OwnerStatement"


End Sub

Do you have Access Security defined on the database - and do you have
permission set for the userID running this on new queries?

It may be that the database is corrupt - try Tools... Database Utilities...
Compact and Repair. You may need to remove this Form's Recordsource and
recreate it - the ~sq_ffrmBillStatement is probably the automatically
generated query recordsource.

John W. Vinson [MVP]