Checkbox to delete

[vbaInet]

I've already explained to you that a Union Query is a read-only recordset so no you can't update any of the fields that way.

 

[raphael99]

Yes VbaInet. Thanks I should look for some output similar to a union query that was fitting the user more readable

 

[vbaInet]

Nothing wrong with using two subforms, one on top and the other just below.

 

[RainLover]

A Union Query is a read-only recordset.

Let's see the SQL.

@Rain, the db in post #30 shows the correct method to use and references the right table. You may have missed that post.

vba

I will give it a rest for a while,

Post 30 does not work for me????

 

[vbaInet]

Strange Rain! What does it not do?

 

[RainLover]

vba Last night I was having problems. Tonight all is good. Your sample works like a charm. I have no idea what happened.

 

[vbaInet]

No problemo old chap! Maybe you were running the original db in error, they're both named the same.

 

[RainLover]

That could very well have been the problem.

Thanks.

 

[raphael99]

VbaInet. Out of curiosity...
Is it not possible to place a single delete button for both the delete queries?
It would be less confusing for the user than to have two delete button.
Is there some arrangments that can be accomplished?

 

[vbaInet]

Think about it, those two buttons do the same thing...

 

[raphael99]

Great VbaInet. It works. I can delete the record .
But now I'm stuck on running Requery.
In Bold is what I have found on the net. But it does not works.

Private Sub cmdeliminaPrestazioni_Click()
DoCmd.RunCommand acCmdSaveRecord
    CurrentDb.Execute "QueryeliminaPrestazioni"
    CurrentDb.Execute "QueryeliminaPIP"    
Me.Requery
    [B]Me.FRMSottMascQueryPIPPerUnire.Form.Requery[/B]
End Sub

Do you have advices?

 

[raphael99]

Hi VbaInet. and all who follow.
I found it:

[B]Parent![FRMSottMascQueryPIPPerUnire].Form.Requery[/B]

or translate:

[B]Parent![Subformname].Form.Requery[/B]

Thanks to all

 

[vbaInet]

Good job!