Unable to delete a record (1 Viewer)

[GSE]

Hi all,

i have a database with one table. I have a form that provides criteria for a search via query. The output is a form that displays the results and allows for record selection and deletion. When i try to delete the record i get an error “the command or action‘delete record’ isn’t available now. If i switch to design mode and then back it works every time.

 

[theDBguy]

Are you able to post a sample copy of your db with test data?

 

[Ranman256]

if your form shows 1 record and no subforms, then it should delete.
if you have a subform, then rules may prevent deletion.
send form image.

 

[GSE]

Are you able to post a sample copy of your db with test data?

Unfortunately i can’t. Its already populated

 

[Gasman]

Unfortunately i can’t. Its already populated

You could try Moke's utility
https://www.access-programmers.co.u...zing-data-for-posted-dbs.306745/#post-1640309

However make sure you use it on a *COPY* of your data

 

[missinglinq]

Would code are you using to retrieve the Record in question?

Linq ;0)>

 

[Pat Hartman]

Is your code dirtying the record when it opens? That might prevent the delete.