how to query on the current form

[kitaeshi]

hi all, i create a form which have a button to append the current entry to another table but i only want to append the current entry tat is open. So how do u set the query to append one entry(the current open entry on the form) using the criteria.

i notice the query only have sum, aver, +- ...etc..

tks.

 

[MStef]

Hello kitaeshi!

Look at "DemoApQA2002.mdb" (attachment)
Adapt it as you need.

 

[kitaeshi]

yeah tats wat i want!!!! but is it possible to add a delete after appending to the query?

 

[MStef]

yes, it is possible. Make a delete query,
add a button on the form and put VBA.

 

[kitaeshi]

Hi Msef, i saw this codes inside the vba, wat does this one do?

Private Sub Form_AfterInsert()

DoCmd.SetWarnings False
DoCmd.OpenQuery "append"
DoCmd.SetWarnings True

End Sub

 

[MStef]

This code run a query which name is "append".

 

[kitaeshi]

y do we need to run a query when we already state it to run on the button when click?

 

[MStef]

When you click on the button, the query will run.