No buttons or commands not working

[aucho22]

Good Morning,

I have a form for users to be able to delete or edit records. I have 2 command buttons (Delete and Save), when I click on them I get this error "the command or action is not available now"... It was working fine before but for some reasons it stopped. Even two other buttons actioned by vba codes do not work (No message popping up for these 2)

I checked:
Allow Additions: Yes
Allow Deletions: Yes
Allow Edits: Yes

Nothing is blocked or locked.

I think it has to do with the query my form is based on, as I tried a dummy form based on a table and the button worked fine...? I tried re-creating query+form and no luck. I did remove a field from my query at some point this morning, not sure if this might be the cause of issue, as this field was not connected to anything in my form.

Any idea what it might be caused by?

Thank you
Aucho22

 

[aucho22]

Alright, solved my own problem

I checked a dozen times my query and found out I had simply put too many joins between tables/queries which caused my query not to be updatable.

So much more to learn... For future reference, check your relationships/joins first

Thank you,

Aucho22

 

[vbaInet]

I checked a dozen times my query and found out I had simply put too many joins between tables/queries which caused my query not to be updatable.

Like the adage goes, "too many hands spoil the broth"